PDA

View Full Version : Solved: How to insert values in rows through for loop



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.

sankartalam
05-16-2008, 10:58 PM
Hi,

I got the solution....

i used the below code for


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

Simon Lloyd
05-16-2008, 11:09 PM
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"