Creating loop using a cell value as the maximum limit

[Kai_TP]

I have extracted the maximum integer value from my data set into cell V20.

On Sheet 3, I would like to have the A column populated by all the integers from 1 to this maximum value (which in this case is 19).

Whilst this would be easy enough just to drag out, I have to do it for many different workbooks, so a simple VBA loop would be really helpful!

Along the lines of:

For i=1 to V20

Cells(i,1).Value = i

End

Thanks

[michson]

Please Login or Register  to view this content.

[Kai_TP]

Thank you for the quick reply! I am still totally new to VBA, and when I try to run/play the code, I get a 'run-time error type mismatch' message. I have changed cells(i,1) to cells(i,13) so that it fills the M column, but otherwise I have copied your code line for line - any suggestions what's happening?

[Kai_TP]

No matter, all fixed - silly mistake. Thanks again!