(Solved) – How do I unhide all rows in VBA from the last row?

  • by
(solved)-–-how-do-i-unhide-all-rows-in-vba-from-the-last-row?

On the spreadsheet, the LastRow is actually 32, but when I run this sub, it’s unhiding everything before Row 30, and leaving both 31 and 32 hidden. Any help?

Dim I As Integer
Dim LastRow As Long
LastRow = Cells(Rows.Count, 4).End(xlUp).Row
For I = 1 To LastRow
    Rows(I).EntireRow.Hidden = False
Next I

Leave a Reply

Your email address will not be published. Required fields are marked *