Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

#value

Posted by Derek Dobson on January 15, 2002 4:27 PM

How do I get a formula to ignore a cell that has a word in it and display the word instead of #value ?

Check out our Excel Resources

Re: #value

Posted by Aladin Akyurek on January 15, 2002 4:32 PM

Derek --

Not sure I understand.

Are you referring to the #VALUE! error?

Aladin

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.