Rearrange Columns on Each Sheet in Workbook

[mjcanty]

Hi Everyone,
I have a macro that deletes unnecessary columns and rearranges the remaining columns perfectly for the active sheet, but there are three other sheets that have the same headers, but different data. My goal is to have the macro delete and rearrange the columns on each sheet. I'm stuck and it's starting to make me go crazy. Please help!

Please Login or Register  to view this content.

[Raymundus]

Hi there,

I'm no expert... Your Kung Fu is stronger than mine, BUT... looks like you could use another For Loop. You are only on the active sheet when you insert your new columns, and there is no instruction to move to the next sheet.

Perhaps before your For x loop, you need to insert a For Each ws in Sheets loop.

Thoughts anyone?

[mjcanty]

Thanks, Raymundus. I tried this, but it inserted additional columns, moving my existing columns to the right.

[jolivanes]

Looks like your rearranging of the columns is outside the For Each ws------Next ws