Weird!!!

I have fixed it now.

When i pasted the code back into my original spreadsheet, I forgot to delete the Application.ScreenUpdating lines.

Works fine now.


Xld, would you have any idea how to resolve my date issue? (see description in sheet attached above)

At present, the 6 columns of data selected are set, but i was wondering if it is possible for this range to move forward 1 column on a weekly basis