Max Wrote:
Think you'd need a sub to do that. Formulas cannot clear cells.
But here's something simple to play with
(does the job with just 2 "clicks")
Select A1:B5, hold down CTRL then select A7:B10
Click inside the namebox*, type a name, say: MyRange
Press ENTER
*the box with the the droparrow just to the left of the "=" sign
Now whenever you want to clear A1:B5 and A7:B10,
just select "MyRange" from the namebox droplist and press Delete
(Just an extra "click" ! <g)
--
Rgds
Max
xl 97
QUOTE]
Hi Max, is there a limitation as to how many selectations I can select?
I tried to select 31 "range" and save it as ""MyRange" but once I
pressed enter, only
19 selectations are selected. The other 12 ranges had to save it as
"MyRange2".
How do I clear the "MyRange" if I wanted to use "MyRange" for other
selections?
--
Lewis Koh
------------------------------------------------------------------------
Lewis Koh's Profile:
http://www.excelforum.com/member.php...o&userid=25712
View this thread:
http://www.excelforum.com/showthread...hreadid=391513