View Full Version : Solved: Delete Column and Row
marreco
01-08-2011, 04:05 PM
good night people
I am using excel 2007
I need a code which delete the column A and column B, column F and G.
Then delete the row 1 and row 2,6,9.
Thanks
zoom38
01-08-2011, 05:39 PM
This is a simple method, I don't know where you're going with it.
Hope it helps.
Gary
'Columns("a").Delete 'individually
'columns("b").delete
Columns.Range("A:B").Delete
Columns.Range("F:G").Delete
Rows(1).Delete
Rows(2).Delete
Rows(6).Delete
Rows(9).Delete
marreco
01-08-2011, 06:12 PM
It helped me a lot
thanks
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.