Referencing using a variable

Mohd_KB · #1 03-01-2018, 03:15 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable	shimulsiddiquee	Excel	1	05-16-2017 07:39 AM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
object variable or with block variable not set	MJP143	Excel	1	02-11-2013 05:07 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM