PC Review


Reply
Thread Tools Rate Thread

Displaying something within a range name in an Excel Header

 
 
=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=
Guest
Posts: n/a
 
      12th Oct 2006
I have the following code to modify the header for the worksheet.

Sub Workbook_BeforePrint(Cancel As Boolean)
Application.ScreenUpdating = False
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = _
"&""Arial,Bold""&12TITLE &""Arial,Regular""&10" _
& Chr(10) & "Last date saved: " &
Format(ThisWorkbook.BuiltinDocumentProperties("last save time").Value,
"dd-mmm-yyyy")
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = "" & Chr(10) & "&P of &N"
.RightFooter = ""
End With
Application.ScreenUpdating = True
End Sub

Where I have TITLE, I want to display the value of the range name "TEST" and
then follow it with TITLE. What do I need to change to get this to work?'

Thanks
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select 'used range' except header row in excel 2007 Anita Microsoft Excel Programming 3 29th Mar 2010 02:13 PM
Named Range Header Row in Excel 2007 NoSpam Microsoft Excel Discussion 0 27th Aug 2009 10:40 PM
Displaying an Excel Range Doug Robbins - Word MVP Microsoft Excel Programming 8 8th Jan 2009 08:04 PM
Printing the contents on a named range in the Header of an Excel s Dots Microsoft Excel Programming 1 9th Dec 2008 04:56 PM
I displaying a range in Time within a cell in Excel. =?Utf-8?B?TW9yaWNq?= Microsoft Excel Misc 1 4th May 2006 01:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:51 PM.