template for deleting columns.....
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 |
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 Jeff wrote: 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 |
All times are GMT +1. The time now is 05:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com