sankartalam
05-16-2008, 10:07 PM
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
For i = 3 To 9
Range("G&i").Select
ActiveCell.FormulaR1C1 = InputBox("Enter Value")
Next
could anyone please help me to resolve my issue.
Thanks In Advance
Sankar.
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
For i = 3 To 9
Range("G&i").Select
ActiveCell.FormulaR1C1 = InputBox("Enter Value")
Next
could anyone please help me to resolve my issue.
Thanks In Advance
Sankar.