Referencing a cells value

[Patrick C. Simonds]

Cell AA6 has a formula that returns a number.

Can some one tell me why when the formula in cell AA6 is returning a 1,
frame 3001 remains visible"


If Range("AA6").Value = 1 Then
Frame3001.Visible = False
GoTo Same3
End If

 

[Patrick Molloy]

well the numbers are binary in memory, so what you see as '1' may be
..999999999987985 for example

unless your formula is rouned ie
=INT( formula)
=ROUND (formula, decplaces)

 

[Patrick C. Simonds]

Sorry but that was not the problem. I tried your suggestion and it still
did not work. I even tried typing a 1 in cell AA6 but that did not work
either.

 

[Patrick C. Simonds]

Please disregard this question

Sorry but that was not the problem. I tried your suggestion and it still
did not work. I even tried typing a 1 in cell AA6 but that did not work
either.