Sub DeleteHiddenRows_Workbook() 'This Microsoft Excel Macro will remove hidden rows from End Sub
'all worksheets in a workbook.
For i = 1 To Worksheets.Count
If Worksheets(i).Visible Then
Worksheets(i).Select
ActiveCell.SpecialCells(xlLastCell).Select
k = ActiveCell.Row
For j = 1 To k
If Rows(j).Hidden Then
Rows(j).Hidden = False
Rows(j).Delete
End If
Next j
End If
Next i
If Worksheets(1).Visible Then Worksheets(1).Select
Showing posts with label delete hidden rows. Show all posts
Showing posts with label delete hidden rows. Show all posts
Tuesday, March 13, 2012
Delete hidden rows
Posted by AG at 1:49 AM 0 comments
Labels: delete hidden rows, Macro
Subscribe to:
Posts (Atom)