Martin_H
Board Regular
- Joined
- Aug 26, 2020
- Messages
- 190
- Office Version
- 365
- Platform
- Windows
Hi,
I have been using this code to delete whole row if the cell in the column G is blank.
I have been using this macro to clean up worksheets with thousands of rows. It works well, but It takes a few minutes to run.
Is there any faster way to do the same job?
Help is much appreciated.
Many thanks.
I have been using this code to delete whole row if the cell in the column G is blank.
VBA Code:
Sub DELETE_BLANKS()
Application.ScreenUpdating = False
Columns("G:G").SpecialCells(xlCellTypeBlanks).EntireRow.DELETE
Application.ScreenUpdating = True
End Sub
I have been using this macro to clean up worksheets with thousands of rows. It works well, but It takes a few minutes to run.
Is there any faster way to do the same job?
Help is much appreciated.
Many thanks.