Thread: Coding Equivalent of CRL-A?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Living the Dream Living the Dream is offline
external usenet poster
  
Posts: 151
Default Coding Equivalent of CRL-A?
On 19/09/2012 11:53 PM, Claus Busch wrote:
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


Try:

Cells.Select

HTH
Mick.
Reply With QuoteReply With Quote