Please note that I am a beginner user of Excel, so please excuse me if i use the wrong terminology.
Im writing a macro which will ask the user to enter the desired raw number, then "in the already selected cell" it will calculate the average of a range that starts from the 4th row of the conlomn of the active cell to the entered row number by the user.
Example:
active cell is B1, the macro will first ask the user for the desired row number (ex. 250), then the macro will calculate in B1 the average of B4:B250
This is my failed attempt
Code:
Sub Macro4()
Dim Value05 As String
Value05 = InputBox("when will it reach 0.5?")
ActiveCell.FormulaR1C1 = "=AVERAGE(B4:B(Value05))" *
End Sub
*
Thanks in advance