View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Referencing a cells value

Please disregard this question

"Patrick C. Simonds" wrote in message
...
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 Molloy" wrote in
message ...
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" wrote:

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