Macro to find last datafield

  • Thread starter Thread starter Patrick
  • Start date Start date
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
 
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 **
 
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
 
Back
Top