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

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 **
"Patrick" wrote in message
. be...
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

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

-----Original Message-----
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


.