If you encounter problems with the macro, you can disable the lines that failed because those were optional extras that I included in the code I posted. I've colour-coded it now. The Red line will fail if you have merged cells in the top row. The Orange lines are not necessary and can be disabled if you only want to apply the table style.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia