Combing text and cell contents in header

[Steven811]

Hi

I wish to combine some text "Due date" and the contents of a cell in a left header, I've experimented and created the following but, the text is ignored. Everything else works okay.

Please Login or Register  to view this content.

'

Any ideas?

[romperstomper]

You are overwriting the LeftHeader you set initially with the subsequent line...

[Steven811]

I agree but, I don't know how to concatenate the two.

Can you help?

[romperstomper]

You can use:

Please Login or Register  to view this content.

I have assumed you meant to use ActiveSheet rather than ws in your loop.

[Steven811]

Fantastic!

I will be naming my first born after this forum.

[romperstomper]

Bit harsh if it's a girl.