Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Operations with hidden cells
Is there a command or function that return any value if a cell is hidden or
active? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hidden cells | Excel Discussion (Misc queries) | |||
Hidden cells ????? | Excel Worksheet Functions | |||
copy only non hidden cells | Excel Worksheet Functions | |||
Chart disappears when source data cells are hidden | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) |