LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Page Header to Include Variable Values

I am working on a macro to create a PivotChart and need this chart to include
some data in the page header. This information pertains to the charting date
range and production goal. The variables are Goal, StartDate, and EndDate and
my current code is as follows:

..LeftHeader = "Date Range: ???" & Chr(10) & "Goal: ???"

Any guidance in terms of how I would represent these variables in this code?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I include a variable in an Excel page header omstefanov Excel Discussion (Misc queries) 0 January 10th 07 07:41 PM
Can't insert a String Variable of Long Date into Page Header Ronny Hamida Excel Programming 3 April 18th 06 05:43 PM
how to include a variable in the header and/or footer of a worksheet tmacke Excel Discussion (Misc queries) 2 April 14th 06 10:13 PM
How can I include a cell's value in a worksheet header? BillSea Excel Programming 1 November 23rd 05 04:33 AM
How can I include the name of the tab in a header without typing . kasaz Excel Worksheet Functions 1 February 25th 05 12:43 AM


All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"