Solved: Delete Column and Row

[marreco]

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]

This is a simple method, I don't know where you're going with it.
Hope it helps.
Gary
[vba]

'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

[/vba]

[marreco]

It helped me a lot

thanks