Select all Data on Active Sheet
 

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,

Select all Data on Active Sheet
 

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,

Select all Data on Active Sheet
 

Range(Range("A4"), ActiveCell.SpecialCells(xlLastCell)).Select


Gord Dibben MS Excel MVP


On Fri, 25 Jul 2008 13:28:16 -0700, 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,

Select all Data on Active Sheet
 

Hi:

That's the problem.....It may or may not be a solid block. There could be
blank cells in the mix.......how do code a CTRL + SHIFT + END function?

"FSt1" wrote:

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,