prima satria
Board Regular
- Joined
- Nov 3, 2007
- Messages
- 63
I sort the data with sort key in column C, and want to delete all empty rows starting from row number 5 automatically using VBA. How to write a code so when the last "fill" row in column C is row number 4 then row number 5 to last will be deleted. And if the last "fill" row in column C
is row number 100 then row number 101 to last will be deleted.
A B C
YEAR WO COST REMARKS
2 2005 25,000 OUTSTANDING
3 2006 3,000 OUTSTANDING
4 2005 100 OUTSTANDING
5 2005 700
6 2007 500
Thx in advance.
is row number 100 then row number 101 to last will be deleted.
A B C
YEAR WO COST REMARKS
2 2005 25,000 OUTSTANDING
3 2006 3,000 OUTSTANDING
4 2005 100 OUTSTANDING
5 2005 700
6 2007 500
Thx in advance.