ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Determine if another cell is hidden in a Formula (https://www.excelbanter.com/excel-discussion-misc-queries/37226-determine-if-another-cell-hidden-formula.html)

JWhales

Determine if another cell is hidden in a Formula
 
Hi!

I would like to display a special message in a cell when another cell
is hidden. Is it possible?

Something like (in cell A2):

=If(IsHidden(A1), A1, "")

I guess I could do it with a user function... but if I use that in a
lot of cells (hundreds) it might significantly slow down the refresh
speed...

Any thoughts ?

J Whales



All times are GMT +1. The time now is 07:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com