Referencing a cells value

  • Thread starter Thread starter Patrick C. Simonds
  • Start date Start date
P

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
 
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)
 
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.
 
Please disregard this question

Patrick C. Simonds said:
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.
Click to expand...
 
Back
Top