+ Reply to Thread
Results 1 to 2 of 2

referencing a cell within a header

  1. #1
    Peekabeaux
    Guest

    referencing a cell within a header

    Is there a way to reference a cell's value in a header? I have a time card
    that within the header is a pay ending from and to date that I must manually
    fill out (argh!). Since the information is already in the spreadsheet every
    week,[ always B5 and F5 ] I would like to be able to reference those cells
    within my header.
    Thanks for any answers.
    Peekabeaux

  2. #2
    Ron de Bruin
    Guest

    Re: referencing a cell within a header

    Hi

    Try this example

    With ActiveSheet.PageSetup
    .RightHeader = "text " & Range("B5").Value & " again text " & Range("F5").Value
    End With


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "Peekabeaux" <Peekabeaux@discussions.microsoft.com> wrote in message news:D429AA2B-7992-4FD6-9730-98F1E31AA919@microsoft.com...
    > Is there a way to reference a cell's value in a header? I have a time card
    > that within the header is a pay ending from and to date that I must manually
    > fill out (argh!). Since the information is already in the spreadsheet every
    > week,[ always B5 and F5 ] I would like to be able to reference those cells
    > within my header.
    > Thanks for any answers.
    > Peekabeaux




+ 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