I am using below code to delete hidden rows, but in my excel i have 1000000 rows it takes hours to delete the rows, do you have any suggestion to improve below code and delete the rows fastest way.
'Dim iCntr As Long
'ActiveSheet.Copy
'For iCntr = 1000000 To 1 Step -1
'If Rows(iCntr).Hidden = True Then Rows(iCntr).EntireRow.Delete
'Next
Bookmarks