Removing Rows from Spreadsheet
Posted by Lee Hitchen on October 22, 2001 11:43 PM
Can anybody please tell me the VBA script to delete rows which do not include figures within the 'ownership' column?
Regards
Manufacturer Ownership
Ford 12
Vauxhall 15
Citreon Delete this row
Puegeot 2
Toyota Delete this row
Mercedes 4
Lancia Delete this row
Fiat 6
Audi 3
BMW 5
Posted by Geoffrey Hurst on October 23, 2001 1:41 AM
You can record a macro :-
- Select the ownership column
- Go to Edit>GoTo>Special>Blanks
- Go to Edit>Delete>EntireRow
