Running Error If then else formula in Macro

[cvishu]

Hi,

Please advice whats wrong i am doing in below code:

Please Login or Register  to view this content.

Note: if the value of cell "h2" is equal to "Zero" then the else part of the code should run however i am still getting the error.

Thanks

Reg,
CVishu

[AB33]

Please Login or Register  to view this content.

[twhite2575]

Change your If statement to say

If Range("H2").Value <> 0 Then