Hi All,
I have a set of data that I'm trying to copy and paste a list of data from, including the heading, from one workbook to a table in another workbook. The data that is being pasted includes changes to the table heading at the destination and I can see by manually recording the process that the table uses a different format (List Objects?) that requires the heading name to be known to allow the paste to occur. I tried to get around this by setting the previous heading name as rName and using this in the code to paste the values - see below - however, I keep getting a Run-time error '1004': Method 'range' of 'object'_Global failed.
This does not work and is where I am getting the error.Please Login or Register to view this content.
As I can do this manually so I assume it must be possible to replicate via VBA. Can anyone please set me straight?
Many thanks,
Bookmarks