Copying data from another workbook using VBA

[DavidBW]

Hello

I know this should be relatively straightforward but the following macro doesn't complete the final step insofar it's not pasting to the destination point

Appreciate your help as always

[davegugg]

Turn off the On Error Resume Next line and see which line is causing an error to occur.

Also, please note the difference between code tags and html tags. Code tags make code much easier to read.

[Alf]

I'm a bit unsure about your code, should not

Please Login or Register  to view this content.

be written as:

Please Login or Register  to view this content.

Alf