that selects all the cells in the sheet for me - regardless of whether they
contain data or not.

--
Regards,
Tom Ogilvy


"stevebriz" wrote:


ajvasel wrote:
What command can I use in my program to select all of the cells in a sheet
containing data despite frequent variances in the number of rows with data? I
can't seem to find it anywhere.

try:

Cells.Select