View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
 
Posts: 599
Default if cell is hidden

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?