Apparently Empty Cell--with formula inside

  • Thread starter Thread starter foamfollower
  • Start date Start date
F

foamfollower

Hi,
I am trying to make a command button become visible if a certain
'reference cell' has a value in it. But, the problem is there's a
formula in the cell
being referenced.

i can't get these to work. that is, to not appear if there is no
value from
the formula in the cell.

If Range("A1").Value > 0 Then Sheets(1).cmdHIDE.Visible = True
or
If Range("A1").Value = "" Then Sheets(1).cmdHIDE.Visible = false

Thanks for any help,

SF
 
Hi
can you post your formula. It may return the result " " (a space). If
this is true change the return to "" ('empty' cell)
 
Back
Top