Simple... It deletes the columns listed in the range...![]()
Sheets("Raw Cost Data").Select ' This is the list of columns that are to be removed. If source file changes, update this list. ' Range("A:A,D:D,E:E,G:G,I:I").Select ' Range("I1").Activate Selection.Delete Shift:=xlToLeft
I even used the record macro to double check and it spits out the same error...
There are merged cells, but none are the left most cell, none with any values, doing it manually causes no errors or warnings at all.
Bookmarks