Posted to microsoft.public.excel.programming

Elaine

external usenet poster

Posts: 106

Delete all entries in selection except activecell

How can I delete all entries from a selection except for the currently active
cell?

In other words, if I have selected the range (A3:a12), I would like to
retain the value of A3 but delete the contents of all other cells.

Thanks for your help.

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
Copy Selection - Transpose Selection - Delete Selection	Uninvisible	Excel Discussion (Misc queries)	2	October 23rd 07 04:18 PM
Delete first character in ActiveCell	Andy	Excel Programming	8	November 17th 04 03:40 PM
Delete rows from activecell	al	Excel Programming	3	September 27th 04 01:07 PM
Use of Selection.Find & ActiveCell	Steve Slechta[_2_]	Excel Programming	4	November 19th 03 02:07 PM
Delete the row where the activecell is located with VBA	Tim Zych[_2_]	Excel Programming	0	July 19th 03 03:57 AM

All times are GMT +1. The time now is 10:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us