If A1 is the header for example for the first column you can use
Range("A1").CurrentRegion.Select
The same as Ctrl *
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"CellShocked" <cellshocked@thecellvalueattheendofthespreadsheet. org wrote in message
...
I want to select the entire contents of a worksheet, but that data set
will change each time I open it as records will be added to it every day.
I want to always choose all records, and there will never be any
non-contiguous rows in the data or blank rows in it.
So I can make a direct call to it and always get all of it by way of
the named range.