Posts by Mohd_KB

    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.

    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

    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