Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Wednesday, August 13, 2008 – Permalink –

Value of Cell in Header

or Footer



The header and footer cannot contain a link to a cell. You can create and run a macro that will put the value of a cell into a footer or header. You could run this macro each time the contents of the specified cell changes.

Sub AssignCenterHeaderToValueInA1OnActiveSheet()
ActiveSheet.PageSetup.CenterHeader = Range("A1").Value
End Sub

Or use it as an Event code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.PageSetup.CenterHeader = Range("A1").Value
End Sub

OzGrid.com:
Information from a cell in a worksheet


Erlandsen Data Consulting:
Insert headers and footers


Chip Pearson:
Headers and Footers


Jan's Computer literacy 101:
Excel Basics: Setup Header/Footer


University of Wisconsin at Eau Claire:
Modifying Header and Footer Information

[Edited entry from 4/27/2005]




See all Topics

Labels:


<Doug Klippert@ 2:26 AM

Comments: Post a Comment

Links to this post:

Create a Link