PDA

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