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

On Wed, 2 Mar 2005 06:47:06 -0800, Hiughs
wrote:

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