WM
I believe the ColumnWidth property will be zero if it's hidden
If Range("A1").ColumnWidth = 0 Then
You could also check that either the row or column for that range were
hidden
Range("A1").EntireRow.Hidden Or Range("a1").EntireColumn.Hidden
but I can't think why ColumnWidth wouldn't work, so I'd probably use that
one.
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com
"Wandering Mage" wrote in message
...
how do i check in a macro whether a given cell is hidden?