Operations with hidden cells

[Hiughs]

Is there a command or function that return any value if a cell is hidden or
active?

 

[Gord Dibben]

Not sure what you're looking for here.

A cell cannot be hidden.

A row or column can be hidden or the contents of a cell can be hidden using
formatting.

In either case, the value of the cell can be returned with a formula such as
=A1

OR do you mean return one value if hidden and another value if active?

That would require code.


Gord Dibben Excel MVP