Header to cell reference

[4lowie]

Hi all

I need to reference a cell for a header, trouble is the reference cell is on a different sheet. I've looked online but I can't find what I'm looking for..

Below is my print code to which I need to add the header reference.
I need to add cell F2 from sheet "Weekly Plan" into the left header on sheet "OffLine Hrs". (Right alignment.)

Thanks for your help.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[RudiS]

Give this a try...

Please Login or Register  to view this content.

[4lowie]

Thanks very much, it worked. You knew it would....

Can we use this to format the text as well? It doesn't want to retain the format i set... I need text size 20 and aligned right. Possible?

Thanks Dave

[RudiS]

Hi,

This will format the header font to size 20, but AFAIK, it cannot be aligned right inside the left header?

Please Login or Register  to view this content.