Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop till no more data
Hi,
How to I fix this so the loop stops when there is no more rows with data on it? The number of rows will change each time the tool is used and I don't want to have to guess every few days as to what number to use. Thanks much. Sub MyLoop For c = 1 to 1500 Call AllocateNew Next c End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide formula in cells till data is available for calc | Excel Discussion (Misc queries) | |||
Loop till value changes | Excel Discussion (Misc queries) | |||
Loop Till the end of used Cell | Excel Programming | |||
How can i Change Autofilter data from top till bottom in macro | Excel Discussion (Misc queries) | |||
macro to loop till end of page | Excel Programming |