Custom Footer (Dynamic text with Static text)

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Some static text boxes, some free text	Anna	Microsoft Word New Users	2	4th Jun 2008 10:09 AM
Creating a custom text export file (inc. header & footer) from a q	=?Utf-8?B?ZWZhbmRhbmdv?=	Microsoft Access Reports	46	12th Dec 2007 07:29 PM
Creating a custom text export file (inc. header & footer) from a q	=?Utf-8?B?ZWZhbmRhbmdv?=	Microsoft Access External Data	46	12th Dec 2007 07:29 PM
Creating a custom text export file (inc. header & footer) from a q	=?Utf-8?B?ZWZhbmRhbmdv?=	Microsoft Access	46	12th Dec 2007 07:29 PM
Unwanted gray is behind text in footer auto-text in Word 2002 (SP.	=?Utf-8?B?RGFuIE1jR2FyaWdsZQ==?=	Microsoft Word Document Management	2	3rd Mar 2005 10:48 PM