Some basic VBA code

[AndreaG]

Apologies in advance - I have read the "VBA programming for dummies" book but I am still struggling with writing VBA code.

I'm sure what I want to do is very straight forward but I can't work it out - please help!

I need to enter number 100 into cell G100, number 101 into cell G200, number 102 into cell G300 etc etc upto number 600.

I'd like it in code as the spreadsheet is a moving document and the requirements might change - so I need to be able to populate it quickly.

Many thanks - hopefully the more I can work with real examples the more I'll understand.

 

[bbott]

Welcome to the board.

Here is one way to do it:

Sub OneToSixHundred()

    Dim x As Long
    
    For x = 1 To 600
        Range("G" & x * 100) = x
    Next x
    
End Sub

 

[Smitty]

Welcome to the Board!

See if this gets you started:

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> foo()<br>    <SPAN style="color:#00007F">Dim</SPAN> x <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br>    <SPAN style="color:#00007F">Dim</SPAN> i <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br>    <br>    i = 100<br>    <SPAN style="color:#00007F">For</SPAN> x = 100 <SPAN style="color:#00007F">To</SPAN> 600<br>        Range("G" & i).Value = x<br>        i = i + 100<br>    <SPAN style="color:#00007F">Next</SPAN> x<br>    <br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

HTH,

 

[bbott]

Apologies in advance - I have read the "VBA programming for dummies" book but I am still struggling with writing VBA code.

I'm sure what I want to do is very straight forward but I can't work it out - please help!

I need to enter number 100 into cell G100, number 101 into cell G200, number 102 into cell G300 etc etc upto number 600.

I'd like it in code as the spreadsheet is a moving document and the requirements might change - so I need to be able to populate it quickly.

Many thanks - hopefully the more I can work with real examples the more I'll understand.

Andrea, I misread your post and started at 1 instead of 100. Smitty's solution should be what you're looking for.

 

[AndreaG]

Many thanks - that was exactly what I needed