This one throws an error stating Run Time Error : 1004 Cannot use that command on overlapping selections.![]()
C.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
I get the same error even if I directly put the code within the if clause and not by calling subroutines. But if I run the for loops individually it is working.
Bookmarks