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
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