title: Excel VBA, IF Statement failing to check if variables match
body: <p>I am trying to compare a programmatic calculation to an existing total line, I declared all of the Variables as Double, however once they are set the Type is showing as &quot;Variant/Double&quot; and the IF statement is not seeing them as matching values.
  I hope I explained this well enough! Please help :) <a href="https://i.stack.imgur.com/RO9aD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RO9aD.png" alt="Screen Shots from Code" /></a></p>
  <p>EDIT: After correcting the declaration: <a href="https://i.stack.imgur.com/kAbyH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kAbyH.png" alt="enter image description here" /></a>
  The IF Statement is still failing</p>