Thread
:
loop till no more data
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_2_]
external usenet poster
Posts: 1,522
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
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]