Coding Equivalent of CRL-A?

[Caveman1957]

When in a worksheet I can manually select all cells by doing a control-
is there an equivalent I can use when coding?

I tried recording a macro and it just enters the particular range tha
was selected so is not dynamic in the way control-A is.

I am trying to do this as a precondition before doing a sort on all th
data

 

[Claus Busch]

Hi,

Am Wed, 19 Sep 2012 09:25:55 +0000 schrieb Caveman1957:

When in a worksheet I can manually select all cells by doing a control-A
is there an equivalent I can use when coding?

try:
ActiveSheet.UsedRange.Select


Regards
Claus Busch

 

[Living the Dream]

Hi,

Am Wed, 19 Sep 2012 09:25:55 +0000 schrieb Caveman1957:


try:
ActiveSheet.UsedRange.Select


Regards
Claus Busch

Try:

Cells.Select

HTH
Mick.