Swap Two Cell Ranges?

[papagorgio]

Hi,

Im trying to swap the contents of "B554:W554" with "B555:W555"

I've search but I'm only able to find macro's that swap individual cells.

Anyone know how I can do this?

I've found this macro that swaps entire rows however I require column A to be fixed.

Please Login or Register  to view this content.

Thanks in advance!

[Paul]

Hi Papa, perhaps something as simple as this will work?

Please Login or Register  to view this content.

[papagorgio]

Wow, that worked perfectly. Excellent. Thanks!!