Macro training course

Hi Guys,

I am refreshing myself with the practice material from the VBA Intermediate Introduction course and I came across a piece of code, called the "CopyHeadings", which would not work. I keep being given a "Runtime Error '9'" and told the "Subscript is out of range".

Is anybody able to help me out with this. I know the reason is probably simple, however, i think I need a fresh pair of eyes.

Specific code can be provided if required!

Thanks
Rees