Posted to microsoft.public.excel.programming

external usenet poster

Posts: 386

Delete formula if....

Hi,

In a workboook of 15 sheets I have a lot of cells with formulas that will
return either useful data (numerical values or text) or nothing ("").

What sub could I use to get excel to check all of the sheets and delete the
formulas from cells that =""? All other cells need left as they are.

Thankyou
LiAD

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
Is there any formula like delete if?	Sasikiran	Excel Discussion (Misc queries)	4	May 16th 08 02:12 PM
delete formula	jason2444	Excel Discussion (Misc queries)	3	July 12th 06 08:18 PM
Delete value but not formula	Big Ant	Excel Discussion (Misc queries)	2	June 26th 06 10:48 PM
Delete Formula	azazel	Excel Worksheet Functions	2	November 7th 05 10:17 PM
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below	Annette[_4_]	Excel Programming	2	September 21st 04 02:40 PM

All times are GMT +1. The time now is 06:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us