Posted to microsoft.public.excel.programming

Gary''s Student Gary''s Student is offline

external usenet poster

Posts: 11,058

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to reset the activesheet usedrange value	Gary Keramidas[_4_]	Excel Programming	5	September 28th 05 03:08 PM
usedRange	GC	Excel Programming	2	March 31st 05 01:44 PM
usedrange	Mike[_94_]	Excel Programming	4	February 17th 05 03:59 PM
UsedRange	Damien McBain	Excel Programming	3	July 4th 04 01:55 PM
Usedrange	Terry VanDuzee	Excel Programming	6	August 10th 03 05:57 PM

All times are GMT +1. The time now is 12:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us