Creating macro
Try
With ActiveCell
.Value2 = "=IF(ISERROR(" & Right$(.Formula, Len(.Formula) - 1) &
"),0," & Right$(.Formula, Len(.Formula) - 1) & ")"
End With
--
HTH
Bob
"Jamie" wrote in message
...
Hi,
Can anyone write a macro for me so that it takes the current formula I
have
in a cell and adds a IF function and iserror fuction around it.
Here is what I would like:
Current formula =A1/B1
after running the macro I would like it to look like this:
=if(iserror(A1/B1),0,A1/B1)
Thanks for your help.
|