Solved: How to insert values in rows through for loop

[sankartalam]

Hi,
I want to insert values through the inputBox() using the for loop in a particluar column for some range of rows. I used the following code but its throughin error

[VBA]
For i = 3 To 9
Range("G&i").Select
ActiveCell.FormulaR1C1 = InputBox("Enter Value")
Next
[/VBA]
could anyone please help me to resolve my issue.


Thanks In Advance

Sankar.

[sankartalam]

Hi,

I got the solution....

i used the below code for

[VBA]
For i = 3 To 9
Range("G" & i).Select
ActiveCell.FormulaR1C1 = InputBox("Enter Value")
Next i
[/VBA]

[Simon Lloyd]

Sankartalam, if you have had a solution or your question is solved please mark your thread solved by using "Thread Tools" at the top of this window and choose "Mark as solved"