Forum Discussion

Copper Contributor

Nov 26, 2020

VBA Copy and Paste between workbooks

Hi, I am trying to write a VBA to embed into a source workbook (this gets renamed for each job), which copies the same row each time (Row 5 on the Data Worksheet) and adds it into the next availa...

Macros and VBA

MegWH

Copper Contributor

Nov 26, 2020

NikolinoDE

Thank you so much for your response. I have just managed to get it working by specifying the PasteSpecial as PasteValues, as you have mentioned below. It turns out that it was quite an easy fix in the end!

Thanks again.

NikolinoDE

Platinum Contributor

Nov 26, 2020

MegWH

You are welcome 🙂

It has give me joy to be able to help you

Wish you a nice day.

Nikolino

I know I don't know anything (Socrates)