2004 macro won't run on 2011

Hi

I'm new to this forum. I have a macro that works perfectly on excel for Mac 2004 but has errors on 2011.

This bit of code fails and the debugger highlights the line I've marked with @@@ :-

The error message prior to clicking the debug button is :-

Run time Error '1004'

A Range is required.Select at least one cell within arange and try again.

Any help would be much appreciated

Please Login or Register  to view this content.

Thanks for your response !

The sheet is added earlier in the macro :-

Please Login or Register  to view this content.