Indentify hidden rows & columns

[R J Solanki]

Hi,
Is there any way to find out how many & which rows & columns are hidden

Thanks in advance

 

[Greg Truby]

The problem is the assumption that UsedRange starts in cell A1 (which of course is usually the case). I think it could be overcome by swapping the red for the blue.

Set rngBlankCol = Range("A1").Offset(...
Set rngBlankCol = rngUsed.Cells(1, 1).Offset(...
 
Set rngBlankRow = Range("A1").Offset(...
Set rngBlankRow = rngUsed.Cells(1, 1).Offset(...

Oh - good catch! Actually, I just did:

    Set rngBlankCol = rngUsed.Range("A1").Offset(, rngUsed.Columns.Count + 2).Resize(, 1).EntireColumn
...    
    Set rngBlankRow = rngUsed.Range("A1").Offset(rngUsed.Rows.Count + 2).Resize(1).EntireRow

Yes, that does appear to be the case. Silly of me to assume rows would behave the same as columns!

Budge over wouldja? I'm sittin' beside ya, cuz I'm in the same boat.

 

[shg]

Wellll ... Excel is kind of row-centric, right? Autofilter only works in one direction, SUBTOTAL ignores hidden rows but not hidden columns, and there are some other examples that don't come to mind.

 

[Peter_SSs]

Wellll ... Excel is kind of row-centric, right?

Perhaps rows have more influence through sheer weight of numbers?

Budge over wouldja? I'm sittin' beside ya, cuz I'm in the same boat.

No problem, I spend plenty of time here in the dunce's corner so I've made sure it is plenty roomy & comfy.