Custom Footer (Dynamic text with Static text)

  • Thread starter Thread starter Maximus
  • Start date Start date
M

Maximus

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???
 
If I interpret your posting correctly:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a footer 2 lines 1
Array To View Specific Sheet(s) 2
Header & Footer text 2
adding footer to all existing sheets in workbook and also to newsheets which is added 1
insert pagenumber in PageSetup in Excel using VB.net 1
Position independent code 4
Change Header/Footer w/ Worksheet Option Buttons 1
Adding current date and contents of a cell in the footer 3

Back
Top