Hello, I am using the macro below to wrap selected formulas with iferror formulas. How can I change it so that instead of showing a 0 if there is an error, it shows a blank cell. If I was writing the formula it would be =iferror((someformulahere),"").
Thanks!
Please Login or Register to view this content.
Last edited by dcgrove; 02-17-2012 at 11:11 AM.
This is a nice idea you haveand a similar bit of code would be useful for error trapping in Excel 2003.
You could try
Explicitly declaring the double-double quote makes it more obvious than using lots of ""s.Please Login or Register to view this content.
Regards.
Last edited by AndyPS; 02-16-2012 at 07:13 PM. Reason: additional comment
That worked!
Thanks!
Great - thanks for the feedback. I'll be adding it to my tool-kit as well.
Modified the code so the "=IFERROR" wouldnt wrap around the formula multiple times if there was already an IFERROR statement in place.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks