template for deleting columns.....

[Guest]

I'm trying automate the process of deleting about 70 columns from a
spreadsheet...I need to find out how this can be done (I'm assuming I need to
run some program to do this).....the columns I need to delete will always be
the same and to do this manually is killing me...any ideas?

Thanks,

Jeff

 

[Dave Peterson]

Try recording a macro when you select some columns and delete them.

You'll see the code that works for you.

If you're anything like me, you may want to hide the columns instead of deleting
them (just another option).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm