Coyping from Excel to an MS Word Header
 

Hi Guys,

I am using a macro that copies and pastes sections of a spreadsheet into MS Word, but what I would also like to be able to do is copy certain text on the spreasheet i.e "The Project Name", which is located in cell "a1" and paste it into the header & footer in MS Word. Is it this possible ?.

Thanks in advance

Mike