I'm not sure what you're asking, but I'll take a guess. If you
are looping through row numbers, you can get the last used row in
column "A" with code like

xxxxx = Cells(Rows.Count,"A").End(xlUp).Row

You might want to provide a few more details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"knowtrump"
wrote in
message
...

Using For n = 1 To xxxxx step 1 or for n = xxxxx To 1 Step -1
is it
possible to state the high number in some generic foremat so
that the
high number does not have to be precisely stated for each new
data list
and you can be sure that the procedure has executed through the
entire
data list?


--
knowtrump
------------------------------------------------------------------------
knowtrump's Profile:
http://www.excelforum.com/member.php...o&userid=19664
View this thread:
http://www.excelforum.com/showthread...hreadid=510873