Error Message:Select Method of Range class Failed

Dear all
I run a large code and a section of the code appears to fail

What is bizare is that I use exactly the same code before and it does not fail
(Both of the worksheets have been cleared from any previous data)

A message Select Method of Range class Failed appears

Please Login or Register  to view this content.

Any ideas why?

Many Thanks
Dora