Copying Values (Error PasteSpecial method)

[Andrew.Trevayne]

Hi everyone,
I have the below codes that will let me open another sheet and copy the values of certain range.
I wanted to paste only the values on my other sheet but I am having this error "PasteSpecial method of Range class failed"

Here is the code:

Please Login or Register  to view this content.

Could you let me know what seems to be the problem and how I can correct it?
Thank you in advance.

Regards,
Andrew

[Keebellah]

I don't have a data file like the one you are using so cannot test.
The problem lies with the Range selection.

Please Login or Register  to view this content.

After that are your settings

[Keebellah]

Try the code like this:

Please Login or Register  to view this content.

[Andrew.Trevayne]

Thanks, but I tried and modified the code and it hanged.

[Andrew.Trevayne]

Try the code like this:

Please Login or Register  to view this content.

Ah! This did it!
Thank you so much!

[Keebellah]

As of Excel 2010 Excel shows the message "Not responding..." this is a real pain in the A but that's the way MicroSoft wrote this.
The process runs in the background and for some stupid reason the message Not Responding is shown , they could have chosen for something like Processing or a progress bar.
To speed it up you could disable events, automatic calsutaion and then set these back to true after completion.

I do not understand why you place the command End when no datafile is selected, with this command all macro processing stops.
I always use Exit Sub instead.