I have the following code to delete blank lines in my sheet.
Worksheets("sheetname").Range("C:C").Select
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
unfortunately I have over 44,000 rows to go through.
I read that xlCellTypeBlanks has an 8,000 plus limitation
I have tried a loop but it takes approx. 3 minutes to run through and delete the empty/blank cells.
I have searched numerous sites for ideas but with little success.
Does any one have a better idea/method to accomplish this task ???
Thanks for the help.
Bookmarks