Ste_Moore01
Active Member
- Joined
- Jul 13, 2005
- Messages
- 467
Hi guys and gals,
How do I find the first empty cell in a column using vba and then delete every row after that?
For example
I would like to find the first blank cell in column G and delete that row and every other row below it.
So rows 6 to 65536 would need to be deleted (or cleared).
Any help would be greatly appreciated.
Thanks!
How do I find the first empty cell in a column using vba and then delete every row after that?
For example
Print Del Notes for Invoiced Goods.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | 97325 | 1 | 1 | 97325 | 1 | 1 | |||
2 | 97325 | 1 | 97326 | 2 | 2 | ||||
3 | 97325 | 1 | 97327 | 3 | 3 | ||||
4 | 97325 | 1 | 97328 | 4 | 4 | ||||
5 | 97325 | 1 | 5 | 5 | |||||
6 | 97325 | 1 | 97325 | 1 | |||||
7 | 97325 | 1 | 97325 | 1 | |||||
8 | 97325 | 1 | 97325 | 1 | |||||
9 | 97325 | 1 | 97325 | 1 | |||||
10 | 97325 | 1 | 97325 | 1 | |||||
11 | 97325 | 1 | 97325 | 1 | |||||
WORKOUT |
I would like to find the first blank cell in column G and delete that row and every other row below it.
So rows 6 to 65536 would need to be deleted (or cleared).
Any help would be greatly appreciated.
Thanks!