The answer is in your code.
Use the With and End With statement
Make sure to use the . (period) as required.
BTW, read up on selecting. In your code it is not needed at all. It slows down the code.
Oh, instead of all the changing of the column widths, would this not work at the end?
Is there a good reason why some columns are deleted and shifted right, others left and other cut?
The deleting and inserting columns is a mixed bag also. Not a good way of doing it. I realize it was a recorded macro but you should clean it up.
Maybe if you explain what you want done, someone will come up with a neater and certainly faster and better piece of code.
Bookmarks