| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting multiple columns in excel that are not in a row
I have a set of data that ranges from column A to AV. In this data I need to
delete different columns that are not in order. For example, I need to delete columns B-D, then columns K-M, O-Z, and AC-AJ . I'm trying to build a VB macro that I can run so I can delete these columns on some 200 different reports. Does anybody have any ideas of a formula that I could use? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting multiple columns in excel that are not in a row
Possibly. But you didn't say anything about why certain columns get deleted,
and others don't. If you're just randomly picking those columns (or its always those particular columns) simply recording yourself deleting the columns would be the easiest way to go. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "jriemens1" wrote: I have a set of data that ranges from column A to AV. In this data I need to delete different columns that are not in order. For example, I need to delete columns B-D, then columns K-M, O-Z, and AC-AJ . I'm trying to build a VB macro that I can run so I can delete these columns on some 200 different reports. Does anybody have any ideas of a formula that I could use? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting multiple columns in excel that are not in a row
Yes, that does work but I really was wanting to know how to write it rather
than record it. This will be used by many people and I would like it to look cleaner than what a recording would produce. Any way of actually writing it? And yes the columns that are being deleted will be constant throught out the different reports. If that helps... "Luke M" wrote: Possibly. But you didn't say anything about why certain columns get deleted, and others don't. If you're just randomly picking those columns (or its always those particular columns) simply recording yourself deleting the columns would be the easiest way to go. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "jriemens1" wrote: I have a set of data that ranges from column A to AV. In this data I need to delete different columns that are not in order. For example, I need to delete columns B-D, then columns K-M, O-Z, and AC-AJ . I'm trying to build a VB macro that I can run so I can delete these columns on some 200 different reports. Does anybody have any ideas of a formula that I could use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reduce excel file size by deleting blank rows and columns?? | Excel Discussion (Misc queries) | |||
| Deleting multiple styles at once in Excel 2003 | Excel Discussion (Misc queries) | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| deleting columns on multiple sheets | Excel Discussion (Misc queries) | |||
| Deleting NEARLY multiple records in excel | Excel Discussion (Misc queries) | |||
Linear Mode
