Forum Discussion
Delete Empty Rows Quickly Looping though all workbooks in Folder
I have more than 200 workbooks in an Folder, and i deletes the empty rows by giving an Range in the code that is Set rng = sht.Range("C3:C50000"). If Column C any cell is empty then delete entire...
Actually these are Google sheets, 1 person works on more than 10+ google sheets in a month so i downloaded them and compile them.
https://imgur.com/EUchGPP
I received this error on the line .AutoFilter Field:=1, Criteria1:="="
https://imgur.com/EUchGPP
I received this error on the line .AutoFilter Field:=1, Criteria1:="="
ShazSh I'd have to see the workbook for which the code fails.