delete columns

[Moh]

hi,

i got 5 columns A,B,C,D,E

Is there a code i can write for a macro to delete all 5 columns

im sure its something simple ;-)

 

[Bob Phillips]

Columns("A:E").Delete

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Moh]

THANKS BOB THAT WORKED PERFECTLY

i have a userform
when the user clicks cancel can i direct them back to the main menu?

 

[Bob Phillips]

What main menu?

Can you remove that signature, every question that you ask cannot be urgent.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Moh]

sorry for the signature

the main menu is a worksheet sheet.("mainmenu")

does that help?

cheers