Well, there are other things that I am going to copy from that sheet to the word document but that part is sorted and now I just want to add the date to the header along with some text each time I run the code. Also instead of copying the date from a cell it also can be made like it picks the date from the computer date when I run the macro i.e. If I run the code today it will paste today's date in the word document header and it never changes.
Hope this clears your queries