selecting ActiveSheet.UsedRange
 

In VBA I can select activesheet.usedrange with
ActiveSheet.UsedRange.Select

How can I accomplish this on the worksheet without VBA?
--
Gary's Student

selecting ActiveSheet.UsedRange
 

Ctrl-End, then Shift-Ctrl-Home

or

Ctrl-Home, then Shift-Ctrl-End

HTH,
Bernie
MS Excel MVP


"Gary''s Student" wrote in message
...
In VBA I can select activesheet.usedrange with
ActiveSheet.UsedRange.Select

How can I accomplish this on the worksheet without VBA?
--
Gary's Student

selecting ActiveSheet.UsedRange
 

The closest I can think of is to:
go to cell A1 (Ctrl + Home) then
hit F5 (or Ctrl + G)
hit Special Cells button,
Select Last Cell
Hold down the Shift key
Hit OK

--
HTH...

Jim Thomlinson


"Gary''s Student" wrote:

In VBA I can select activesheet.usedrange with
ActiveSheet.UsedRange.Select

How can I accomplish this on the worksheet without VBA?
--
Gary's Student

selecting ActiveSheet.UsedRange
 

Try

ctrl-Home

then

Shift-ctrl-End


--
Stefano Gatto


"Gary''s Student" wrote:

In VBA I can select activesheet.usedrange with
ActiveSheet.UsedRange.Select

How can I accomplish this on the worksheet without VBA?
--
Gary's Student

selecting ActiveSheet.UsedRange
 

I was going to suggest similar.

FWIW, the topLeftCell of the usedrange is not necessarily A1. Can't think of
a keyboard method to reliably select the UR if it starts below & to right of
A1 and the top row & left col of the UR are empty except for formats.

Regards,
Peter T

"Stefano Gatto" wrote in message
...
Try

ctrl-Home

then

Shift-ctrl-End


--
Stefano Gatto


"Gary''s Student" wrote:

In VBA I can select activesheet.usedrange with
ActiveSheet.UsedRange.Select

How can I accomplish this on the worksheet without VBA?
--
Gary's Student

selecting ActiveSheet.UsedRange
 

Thank you all very much.
--
Gary''s Student


"Jim Thomlinson" wrote:

The closest I can think of is to:
go to cell A1 (Ctrl + Home) then
hit F5 (or Ctrl + G)
hit Special Cells button,
Select Last Cell
Hold down the Shift key
Hit OK

--
HTH...

Jim Thomlinson


"Gary''s Student" wrote:

In VBA I can select activesheet.usedrange with
ActiveSheet.UsedRange.Select

How can I accomplish this on the worksheet without VBA?
--
Gary's Student