Deleting Empty Rows in Excel VBA
Data Nik
0:00 / 0:00
Deleting Empty Rows in Excel VBA
19 743 просмотра · 6 лет назад
Data Nik
1,12 тыс. подписчиков
19 743 просмотра · 6 лет назад
The code for the script is:
Sub DeleteRows()
On Error Resume Next
Range("A3:A" & Worksheets(1).UsedRange.Rows.Count).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
If you have any questions, feel free to write them down in the comments.