if cell is hidden

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 0
Sorting hidden cell 1
macro triggered by changes to cell only works if i run it twice 3
Clear contents of cells hidden by autofilter 3
Conditionally Hiding Comment markers. 5
read hidden cells; vba 6
array-to-row autofilter issue 3
Can't find project or liabrary 2

Back
Top