VBA copy header to all additional worksheets

Dear Excel Experts,

I've been trying the whole day and kinda give up on this. Am trying to do this automatically. Copy header from first worksheet to all other worksheets. But come to no avail. Below are my series of coding I've tried:-

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I just don't know what is actually wrong with it. Please help. Really need this for 147 worksheets.

This works for me:

Please Login or Register  to view this content.

Originally Posted by cantosh

This works for me:

Please Login or Register  to view this content.

Hi there,
Thank u so much! This works as I wish!