I need Excel macro help

I have a macro that I am trying to run in order to put formulas on groups of data.

The average formula that I use within the macro needs to use a varying range, I attempted to use Ctrl up in order to deal with the varying range. I found that when I then run the macro again it doesn't input the ctrl up it inputs how ever many cells it went up into the range so it then messes up the answer I get in the average cell because the range is always 13 as opposed to it changing depending on how much data there is.

Here is the VBA code for the Macro

Sub MOS_Formula()


' MOS_Formula Macro



[login to view URL](xlDown).Select

[login to view URL](xlDown).Select

[login to view URL]

[login to view URL](1, 0).Range("A1").Select

[login to view URL]

[login to view URL]("A1:K1").Select

[login to view URL] = True

[login to view URL](0, 3).Range("A1").Select

[login to view URL] = False

[login to view URL] = "=AVERAGE(R[-13]C:R[-1]C)"

[login to view URL](-1, 2).Range("A1").Select

[login to view URL]

[login to view URL](1, 0).Range("A1").Select

[login to view URL]

[login to view URL](0, 2).Range("A1").Select

[login to view URL] = False

[login to view URL] = False

[login to view URL] = "=RC[-2]/RC[-4]"

[login to view URL](0, 1).Range("A1").Select

[login to view URL] = False

[login to view URL] = "=(RC[-3]+RC[-2])/RC[-5]"

[login to view URL](1, 0).Range("A1").Select

[login to view URL](xlToLeft).Select


End Sub

This all works great except for the line that includes the average formula.

Taidot: Excel, Visual Basic, Tietojenkäsittely, Tiedonsyöttö

Näytä lisää: need excel macro input data, need excel macro, i need a macro programmer, i need electrical engineering help edmonton, i need excel data entry, i need excel expert, i need someone to help me for my assignment of service marketing, i need someone to help me write a paper on leviathan thomas hobbes, i need electronic engineer help, i need graphic design help, i need interior design help, i need someone to help me to design my bachpack, i need web design help, i need a macro wirtten and need a freelancer, i need android programming help, i need an interpreter help me, i need customer support help yahoo, i need excel help, i need excel help in agra

Tietoa työnantajasta:
( 1 arvostelu ) Minneapolis, United States

Projektin tunnus: #31519284

Myönnetty käyttäjälle:

(312 Arvostelua)

14 freelanceria on tarjonnut keskimäärin $32 tähän työhön


(488 arvostelua)
(482 arvostelua)
(334 arvostelua)
(137 arvostelua)

Hi, I hope you are doing well I am a professional on SQL server, VBA programming, MS access and also in power BI. I am doing this job since 2010.I can handle your project in a very prudent manner. Give me more details Lisää

$25 USD 5 päivässä
(27 arvostelua)
(29 arvostelua)
(38 arvostelua)

Hi there, I checked the attached file and it appears that we can solve this quickly. I have a couple of questions to ask first. I am hoping for the opportunity to complete this project for you. Please feel free to con Lisää

$15 USD 1 päivässä
(19 arvostelua)

Hi I have read your project description. I am interested to work on this project. My priority target is customer satisfaction. I able to do this project for you easily and quickly, Knock me for more details. Thank you.

$30 USD 3 päivässä
(12 arvostelua)

Hi, I check your [login to view URL] is awesome work for me. I Have experience in Advance Excel with Dynamic Dashboard Using VBA, VBA Macros, Power Bi Visualization, DAX Function, Power Query, Power Pivot and knowledge Lisää

$25 USD 1 päivässä
(2 arvostelua)

Hi, I understand you are looking for an Excel Specialist. I can do this job within 1 hour. I have more than 5+ years of tremendous experience in creating customized applications using Excel VBA. Thank you for taking Lisää

$10 USD 1 päivässä
(1 arvostelu)

Hey, I hope you are doing well. I can assist you with your excel task, as I have advance Excel skills and I've been providing my services in this field for the last 5 years. I've extensive knowledge of Data Filters, D Lisää

$150 USD 2 päivässä
(1 arvostelu)

I have completed [login to view URL] and I have data Entry Experience for 1 year. I will complete it Correctly and I will Do it in Alloted time.I will do it clearly and with Sincerity

$20 USD 7 päivässä
(0 arvostelua)