Excel loop but range determined by sheet

[Maha09]

Hi

I've been trying to write a code in excel for the whole day. Can someone please help.

I want to do a loop that you dont specify a range but it reads it from excel say for instance
A1 = 3
A2= 6

for i = Cell(A1) to cell(A2)

so if i update cell A1 and A2, it will automatically update my values when i rerun my macro.
Hope this makes sense
Thanks

 

[ColinKJ]

Hi Maha09,

You could try:

For i = Cells(1, 1).Value To Cells(2, 1).Value
 
Next i

ColinKJ

 

[Maha09]

Thank you so much

Really appreciate it