ExcelBanter - Custom Footer (Dynamic text with Static text)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Custom Footer (Dynamic text with Static text) (https://www.excelbanter.com/excel-programming/387107-custom-footer-dynamic-text-static-text.html)

Maximus[_3_]

Custom Footer (Dynamic text with Static text)

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???

JLGWhiz

Custom Footer (Dynamic text with Static text)

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???

All times are GMT +1. The time now is 12:09 AM.