Posted to microsoft.public.excel.programming

choice[_2_] choice[_2_] is offline

external usenet poster

Posts: 84

Clear Blank Cells

In B1 I have =if(A1="this","that","") and continuing down b:b

i then copy b:b and paste special (value) into c:c

I have a sumproduct equation that runs off c:c. the problem is that
apparently the blank cells ("") arent really blank. I get a #VALUE error.
How can I find all the blank (''") cells and clearcontents?

Thanks in advance
jeff

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 write a macro that will clear validated cells to blank?	JAbels001	Excel Worksheet Functions	3	November 20th 08 05:20 PM
Clear Blank cells	choice[_2_]	Excel Programming	0	September 23rd 07 12:32 AM
How to clear 'blank' cells	CaroleO	Excel Discussion (Misc queries)	2	March 2nd 07 02:56 PM
clear range of cells if another becomes blank	bgg	Excel Worksheet Functions	3	January 17th 07 11:32 PM
Clear blank cells	Reed[_3_]	Excel Programming	4	January 22nd 05 01:00 AM

All times are GMT +1. The time now is 05:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us