View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maximus[_3_] Maximus[_3_] is offline
external usenet poster
 
Posts: 3
Default 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???