Posted to microsoft.public.excel.misc

RDC

external usenet poster

Posts: 3

delete contents of cell

I have two questions, firstly I want to delete a cells value (it has a
numerical value in it) by typing the word "dead" into another cell.

Secondly, I have large spreadsheet with deals on, can I somehow run a macro
to remove all those deals with the "Dead" in the row to another spreadsheet?

Thanks

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 can I delete the contents of a cell without deleting the formu	6js59	Excel Discussion (Misc queries)	0	June 3rd 08 07:01 PM
Delete cell contents	Rob[_4_]	Excel Discussion (Misc queries)	7	April 10th 07 12:34 PM
copy paste delete cell contents	Garry	Excel Discussion (Misc queries)	0	March 27th 06 08:26 PM
Delete all contents of cell but one word	Hayette Hasham	Excel Discussion (Misc queries)	5	January 18th 06 08:20 AM
Delete row based on contents of cell	AndyG	Excel Discussion (Misc queries)	6	November 17th 05 10:08 PM

All times are GMT +1. The time now is 05:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us