Forever_EX
New Member
- Joined
- Mar 26, 2018
- Messages
- 22
I need code that will:
Find the first blank row in a set of data (the first blank row is ALWAYS at the bottom end of the data)
Highlight that row and every row below it
Delete
I tried this code:
(I use Column A because that always has an entry.)
Unfortunately, it's leaving 1 blank row still at the end every time! Any help?
Find the first blank row in a set of data (the first blank row is ALWAYS at the bottom end of the data)
Highlight that row and every row below it
Delete
I tried this code:
Code:
'Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
(I use Column A because that always has an entry.)
Unfortunately, it's leaving 1 blank row still at the end every time! Any help?