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.
Range("Table1[[#Headers],[rName]]").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
This does not work and is where I am getting the error.

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,