| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenating two variable fields into a static length text field | Excel Worksheet Functions | |||
| Static Date in Header/Footer | Excel Discussion (Misc queries) | |||
| Compare text in cell to custom text format?? | Excel Discussion (Misc queries) | |||
| Use custom format to add text to a text entry. | Excel Worksheet Functions | |||
| Combine Formula and static Text | Excel Discussion (Misc queries) | |||
![Maximus[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
