Data copy from one file to another

  • Hello,

    I am a beginner in Excel VBA, so I would need your help by this macro:

    I wrote the problematic line with red colour.

    Thank you for your help in advance.



  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

    How to use code tags

    Just highlight all of the code and press the <> in the post menu above button to add the code tags.


  • Dear royUK,

    Thank you, but this has not solved yet my problem. The error message still appears.

    Does anyone have any other ideas?

    Thank you for your help in advance.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!