Run time error 438 when attempting to copy and paste into another workbook

Hi All,

I'm getting a run-time 438 when attempting to copy and paste from one worbook to another. Any help appreciated.

Please Login or Register  to view this content.

You should close the code tags with this
[/code]

Also you do not indicate where the error occurs.

You just need to paste in one cell, it should past all the data.
Assuming the workbook is opened, and the sheets are there and not protected.

Please Login or Register  to view this content.

If you continue to have problems, possibly supplying a sample would help.