+ Reply to Thread
Results 1 to 3 of 3

Display result of formula in header?

  1. #1
    Hubitron2000
    Guest

    Display result of formula in header?

    I want my header to say "yyyy results", where yyyy is the current year.

    Any suggestions?

  2. #2
    CLR
    Guest

    RE: Display result of formula in header?

    With the current year entered in A1,

    Sub CellValueInHeader()
    With ActiveSheet.PageSetup
    .LeftHeader = Range("a1").Value & " Results"
    End With
    End Sub

    Vaya con Dios,
    Chuck, CABGx3



    "Hubitron2000" wrote:

    > I want my header to say "yyyy results", where yyyy is the current year.
    >
    > Any suggestions?


  3. #3
    Bernard Liengme
    Guest

    Re: Display result of formula in header?

    Here is a Workbook subroutine - in VBA Editor Project click ThisWorkbook;
    and copy Sub there.

    Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Dim dte As Date
    dte = Date
    With ActiveSheet.PageSetup
    .LeftHeader = Format(dte, "yyyy") & " Results"
    End With
    End Sub

    Found in Google Newsgroup search; acknowledgement to Bob Philips in
    microsoft.public.excel.misc Fri, Nov 4 2005 1:01 pm

    best wishes

    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "Hubitron2000" <[email protected]> wrote in message
    news:[email protected]...
    >I want my header to say "yyyy results", where yyyy is the current year.
    >
    > Any suggestions?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1