MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Test for Hidden


Posted by Don on November 05, 2001 7:47 AM

My macro has the following line:
ActiveCell.Offset(2, 0).EntireRow.Activate
After that, I want to check to see if that row is hidden. How do I check for visible or hidden status?


Posted by Mark O'Brien on November 05, 2001 10:08 AM

In my example I hid row 3 of sheet 1. This code will test the hidden property:

If Sheets("Sheet1").Rows(3).Hidden = True Then
MsgBox "Hi"
End If

Hope this helps.