repeat header rows after VBA paste

[Homegrownandy]

If i enter data manually into the table it will repeat header rows (as it should).





But im using code that will use the pasteappend function.



When this code is ran the headers will not repeat.



Note: I Can't change settings inside "smart cut and paste". Ifi change these settings i get a VBA error saying the command is not available.


I can manually fix this by clicking the table > turning off the "repeat header rows" setting then turn it back on. That works fine.



Is there a way to cycle through that process with VBA?


Andy.