Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Averaging columns | New Users to Excel |