I want to grab the text in a cell (company's name) and automatically copy it to the header using a macro. Thanks for any help. Mike