selecting ActiveSheet.UsedRange

[Gary''s Student]

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

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

[Bernie Deitrick]

Ctrl-End, then Shift-Ctrl-Home

or

Ctrl-Home, then Shift-Ctrl-End

HTH,
Bernie
MS Excel MVP


"Gary''s Student" <[email protected]> wrote in message
news:[email protected]...
> In VBA I can select activesheet.usedrange with
> ActiveSheet.UsedRange.Select
>
> How can I accomplish this on the worksheet without VBA?
> --
> Gary's Student

[Stefano Gatto]

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

[Jim Thomlinson]

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

[Peter T]

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" <[email protected]> wrote in message
news:[email protected]...
> 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

[Gary''s Student]

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