Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
Test for HiddenPosted by Don on November 05, 2001 7:47 AM
My macro has the following line:
After that, I want to check to see if that row is hidden. How do I check for visible or hidden status?
|Check out our Excel VBA Resources
Re: Test for HiddenPosted 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
Hope this helps.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.