hi
this will select all data from A4 to last row and over to column h provided
that column a is a solid block of data.
Range(Range("A4"), Range("A4").End(xlDown).Offset(0, 7)).Select

regards
FSt1

"Theresa" wrote:

Hi:

I need to create part of a macro to start at cell A4 on the active sheet and
then select all data on the sheet. The number of columns will remain the
same but the number of rows will constantly change.

Thanks,