Error pasting data (including headings) into an excel table when heading is variable

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.

Please Login or Register  to view this content.

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,

That's not the right syntax. If Headers and rName are variables, they don't belong inside the quotes.

Please post an example workbook and code so that we can help you further.

Thank you for your input walruseggman. I figured it was the wrong syntax and that rName may have been part of the issue but after a long day of tinkering with code I have decided to look at my requirements from a different angle. Instead of following through with my original method, I have opted for a simpler solution and have ditched the tables to allow me to use vba methods I am more familiar with.

I may revisit this issue some time in the future where time permits otherwise my issue has been resolved for now. Thanks again!