PasteSpecial Causing "Range Not Found Error"

[wigman27]

Hi,

I am getting this weird and random error. I have written the function below that takes a range, copies it and pastes as a picture in a range.

Randomly, when it gets to pasteRange.PasteSpecial, it will throw an error that it can't find the range. If I enter debug it works perfectly.

It is almost like it's going too fast for itself. It just need to chill for a minute and it finds the range.

Has anyone else had this issue?

Please Login or Register  to view this content.

[Greg M]

Hi there,

It's very difficult to debug your problem without access to your workbook, but I have seen comments like the following MANY times in this forum!

Randomly, when it gets to pasteRange.PasteSpecial, it will throw an error that it can't find the range. If I enter debug it works perfectly.

This problem can be caused by the "pasterange" variable referring to a Defined Name, but not being not fully-qualified - i.e. it does not include a reference to the worksheet. This means that the code will try to find the specified range on whichever worksheet happens to be active when the code is executed, rather than on the worksheet which you want to use.


You should use a fully-qualified reference such as the following:

Please Login or Register  to view this content.

rather than:

Please Login or Register  to view this content.

Almost invariably, when you step through the code using the debugger, you select the intended worksheet before you start - hence no error condition occurs.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[wigman27]

Well, don't I feel like a right goose.

That is something I am very particular about for that very reason and here I haven't done it...

I even set up the variables further up to do it and still didn't...

Thanks mate. Really appreciate it. Let's hope that fixes it.

[Greg M]

Hi again,

Many thanks for your feedback.

Don't beat yourself up over it - we've all done that at some stage!

You're welcome - glad I was able to help.

Regards,

Greg M