I am trying to assign a variable in VBA but when the division is by zero i get an error.
I would like to replace the zero with a figure to pass the error.
dim Variable1 as double, Variable2 as double,
Variable1 = Range("A1).value
Variable2 = Range("A2).value
Dim PercentReq as double
PercentReq = Variable1/Variable2*100
"runtime error"
Division by Zero
Thanks for any help
Bookmarks