Deleting multiple columns in excel that are not in a row

J

jriemens1

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?
 
L

Luke M

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.
 
J

jriemens1

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top