View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jriemens1 jriemens1 is offline
external usenet poster
 
Posts: 2
Default 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?