I'm not 100% sure what you're asking, can you post an example of what you have pre-macro and then the desired results?

One thing to remember is that when deleting columns, you always want to go right to left since if you delete Column C, Column D will become Column C.