I have a large data set of values some with the value of 0. I am attempting to calculate another worksheet by dividing 2 by these values using VBA...Unfortunately an error message keeps occuring as obviously you are not allowed to divide by 0...Is there any smart way round this? Unfortunately I am unable to adjust the data values so as to eliminate the zero values...
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA
- Thread starter coquinn
- Start date
Hello Coquinn,
What do you want to happen in the other sheet when zero is encountered on the first one ? Do you just want to skip it ?
You could use an IF statement to check if the range is zero.
If rng = 0 then
'code to handle zero here
End If
Ciao,
Don.
What do you want to happen in the other sheet when zero is encountered on the first one ? Do you just want to skip it ?
You could use an IF statement to check if the range is zero.
If rng = 0 then
'code to handle zero here
End If
Ciao,
Don.
Upvote
0
