Forum Discussion
How to remove hidden rows?
Hello, I am working on a spreadsheet used for employee scheduling at my office. Recently, I hid over 200 rows in one sheet of the workbook. Today I attempted to remove these hidden rows following a ...
Are you considering VBA?
Sub DeleteHiddenRows()
Dim ws As Worksheet
Dim rng As Range
Dim row As Range
Set ws = ActiveSheet
Set rng = ws.UsedRange
For Each row In rng.Rows
If row.Hidden Then
row.Delete
End If
Next row
End Sub