I'm trying to create a header that will pull in data from a mergerd cells
which are typically located in mergers cells C4-G4, C5-G5, etc.

I want the header to appear as:-

" Project" & Ative sheet cel C4-G4
" Address" & Active sheet cell C5-G5.....

I've established from previous posts that the code should go in the workbook
before print event but not really got any further....

Any ideas?