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