On error resume next will not get rid of the error if there are no visible cells.
You need to change this line
![]()
If Range("A2:A" & LastRow).SpecialCells(xlCellTypeVisible).Count > 2 Then
On error resume next will not get rid of the error if there are no visible cells.
You need to change this line
![]()
If Range("A2:A" & LastRow).SpecialCells(xlCellTypeVisible).Count > 2 Then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks