G Guest Mar 2, 2005 #1 Is there a command or function that return any value if a cell is hidden or active?
G Gord Dibben Mar 2, 2005 #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
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
