Macro to delete cols from col BJ to col NO

[I need excel help]

Hello all ,

i have 3 x macros that can delete rows before , after and between .

But now i needing to get one that will delete all data and cols from and including col BJ right along to col NO .

Thanks .

[Richard Buttrey]

Hi,

Presumably

Please Login or Register  to view this content.

[I need excel help]

Thanks for that but i dont know how to write this .
Cant get your macro to work .
Thanks .

[I need excel help]

These are the 3 x delete rows macros i have , im not sure how to put

Range("BJ:NO").Columns.Delete

into my macros .
Thanks .

[Arkadi]

Which of your macros needs to delete those columns? If all 3 do, then paste the code into all 3 modules. It does not matter if you do it before or after deleting rows.

[I need excel help]

I needing a totally independant macro , a 4th to delete these cols .
Thanks . .

[Richard Buttrey]

....stating the obvious I suppose but what is stopping you writing another macro procedure?

Did you create the other three or just inherit them.

[Arkadi]

In any of your modules just put

Please Login or Register  to view this content.

[Richard Buttrey]

I needing a totally independant macro , a 4th to delete these cols .
Thanks . .

Please Login or Register  to view this content.

[I need excel help]

Thanks a bunch guys both were perfect .