469,167 Members | 2,072 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Macro needed for MS Excel to change "#VALUE!" text into $0.00 integer

Hi, I need a VB Macro for MS Excel to change "#VALUE!" text into $0.00 integer in columns E&F only.

Thanks.
Mar 25 '10 #1
1 1215
SammyB
807 Expert 512MB
I don't think that you really want a macro. That would wipe out the formula, then if the data changed, you'd want the formula back. Just wrap the formulas in E and F with an IFERROR function.

For example, if E1 contains =SUM(A1:C1)
then change the formula to =IFERROR(SUM(A1:C1),0)

Then just auto-fill the rest of the rows.
Mar 25 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Stephan Walter | last post: by
1 post views Thread by kscdavefl | last post: by
3 posts views Thread by Frankie | last post: by
17 posts views Thread by sounak | last post: by
3 posts views Thread by param | last post: by
reply views Thread by marknoten | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.