Hi everyone,
My requirement is to delete empty/blank rows from excel except headers , i used insert/delete rows , but it takes more time to delete if 1000’s of records , so i tried an alternate of invoke vba with clear contents , but that adds blanks spaces , so i need delete blank rows in excel with vba any solutions
I am trying to use the below code but getting some errors macros disable when it is actually enabled , but idk how to use this code and pass inputs in invoke vba
@Rahul_Unnikrishnan
Sub DeleteExceptFirst()
Rows("2:" & Rows.Count).ClearContents
End Sub
@Palaniyappan @Yoichi @supermanPunch
Thanks in advance