Macro to find last datafield

P

Patrick

Hi, how it's possible to find the last datafield in a range where you not
known the amount of data.
How you can select the data in an xls.

Thanks

Patrick
 
P

Paul B

Patrick, this will select the last thing in Column A, is that what you need?
Range("A65536").End(xlUp).Select

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
G

Guest

If the data in the range is always in a single block (that
is, no blank rows or columns), then

rng.Cells(1,1).CurrentRegion

will give you the part of the range which actually
contains data.

Regards, Andy Keen
 
Top