johnbird1988
Board Regular
- Joined
- Oct 6, 2009
- Messages
- 199
Hello
I would like some advice.
On one of my sub I have over 25 different calculations in VBA that get used to create a value. I am having problems where if one of the calculations is divided by zero then I get an error message.
At the moment I am using the on error resume next. But this does not always work. I would like something like a IFERROR equivalent.
How would you approach this?
Thank you
John
I would like some advice.
On one of my sub I have over 25 different calculations in VBA that get used to create a value. I am having problems where if one of the calculations is divided by zero then I get an error message.
At the moment I am using the on error resume next. But this does not always work. I would like something like a IFERROR equivalent.
How would you approach this?
Thank you
John