Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cells value
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cells value
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cells value
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing cells based on conditions in other cells | Excel Discussion (Misc queries) | |||
Referencing the same cells | Excel Discussion (Misc queries) | |||
Referencing Cells | Excel Worksheet Functions | |||
Referencing cells | New Users to Excel | |||
Referencing Cells in VB | Excel Programming |