If I interpret your posting correctly:

Sheets("Bid5").PageSetup.LeftFooter = Range("B13").Value & " - CDC Quote"

"Maximus" wrote:

I am trying to insert a custom footer using a cell reference... the
snipet below works fine but I need to add a static piece text to the
footer as well and I am not sure how to do that.

I need to pull the value of B13 and then add the text " - CDC Quote"
to it.


Sheets("Bid5").PageSetup.LeftFooter = Range("B13").Value


ideas???