Brian

Posts: n/a

hide "#VALUE!"

My worksheet is linked to a web query and the value of many cells is
"#VALUE!". The message is "value used in formula is wrong data type". Due to
the nature of the web query, I can live with this without making changes
however I would simply like to "hide" or show a blank cell if the cell shows
this message. I apprectiate suggestions to do this. Thank you.

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
hide column but show chart	Svetlana	Charts and Charting in Excel	1	January 14th 05 09:49 AM
Excel - hide erroer values	Kathrine J Wathne	Excel Discussion (Misc queries)	1	January 10th 05 10:13 PM
Hide Value of Cell	Mark	Excel Discussion (Misc queries)	1	December 23rd 04 05:51 PM
hide column	varun	New Users to Excel	1	December 3rd 04 02:13 AM
Conditional Hide function for Excel	mr.woofies	Excel Worksheet Functions	1	October 28th 04 03:04 PM

All times are GMT +1. The time now is 10:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us