Cell Referencing in Header/footer

[a-man]

Hi,

I would like to reference Cell values in my header/footer. I currently have the following code:

Please Login or Register  to view this content.

The problem im having is that i would like to have multiple lines in my header/footer. Eg. i would like cell A1 to be displayed on the top left, and A2 displayed on the top left, but below the A1 value.

How can I do this?

Regards
A

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[aalik534]

anyone plz reply

[TMS]

anyone plz reply

I did Have you bumped the wrong thread?

[a-man]

Please Login or Register  to view this content.

Regards, TMS

Hi,

Thanks for your response. I edited your code to suit my needs as follows:

Thanks for your reply. I edited the code to suit my needs as follows:

Please Login or Register  to view this content.

However, i now run into the issue that i have to run the macro on every sheet for this to apply.

How do i apply this code for the header to every sheet and so that it is automatically updated?

Your assistance would be much appreciated.

Regards
A

Edit: I have attached a dummy file with the code.

[TMS]

Now, you see, this is what we call "scope creep". The original question was answered so, strictly speaking, this thread should be marked solved.

Whatever, try:

Please Login or Register  to view this content.

Regards, TMS