| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
loop till no more data
dim lr as long
lr=cells(rows.count,"a").end(xlup).row for c=1 to lr -- Don Guillett Microsoft MVP Excel SalesAid Software "SLP" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
loop till no more data
Thanks...I'll give that a try tomorrow. Enjoy the rest of your day!
"SLP" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
loop till no more data
Thanks. I'll try that tomorrow. Enjoy the rest of your day!
"Don Guillett" wrote: dim lr as long lr=cells(rows.count,"a").end(xlup).row for c=1 to lr -- Don Guillett Microsoft MVP Excel SalesAid Software "SLP" wrote in message ... 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 . |
| Reply |
| 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 | |||
Linear Mode
