Copying from one sheet to another sheet...

[puuts]

I just want to copy the value of the below range

Please Login or Register  to view this content.

Please Login or Register  to view this content.

and paste it to the other workbook, sheet name "XAMPP"in the last row of Column A.

Please Login or Register  to view this content.

I'm getting an error "Application-defined or object-defined error" in the highlighted line above.


"wb" is declared as global.

Please Login or Register  to view this content.

[romperstomper]

Let's start with a better title, please.

Then I suggest you use xlUp rather than xlDown when selecting the copy range or you'll copy the entire columns...

[puuts]

Hi Rory,

Sorry for that, I have change the thread title. I'm getting an error on the highlighted line, could you please advise why i'm getting that error?

[Winon]

@ romperstomper,

Let's start with a better title, please.

I secong that!

Then I suggest you use xlUp rather than xlDown when selecting the copy range

And this should solve the problem.

[puuts]

Hi Winon, where it my code should i change?

Could you please advise?

[Winon]

Hi puuts,

It is just this one, you need to change to:

Please Login or Register  to view this content.

And that should do it. If not you would have to upload a sample workbook, complete with your code, for us to have a look at.

[puuts]

It works!, I should review back vba 101. Thanks a lot Winon and Rory!

[Winon]

Hi puuts,

You are welcome.

@ romperstomper,

Hello Rory,

Hope you don't mind me butting in here.

[romperstomper]

Not at all - butt away.