VBA - Clearing existing formatting when adding table

[vba_monkey]

Hello,

I'm using VBA to add a table to a sheet but when I do so, it doesn't clear any existing formatting when applying my style. If you add the table manually, you can right click on the style and select 'Apply and Clear Formatting'.

I've tried using the recorder to see what I get but it only uses:

ActiveSheet.ListObjects("Table1").TableStyle = "Table Style 1"

This is the same code I used to apply the style myself which doesn't remove the existing formatting. Does anyone know how to achieve this please?

 

[NoSparks]

see if this page of member jkpieterse helps

 

[vba_monkey]

Thanks, that was a great help.