Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

Thread: Page Numbering Formula

  1. #1
    Join Date
    14th June 2006
    Registered Users

    Page Numbering Formula

    Hello; I'm not at all good with Excel Macros or VBA scripts so please forgive me if this is a simple question..

    Here's what I need to do. I have a spread sheet that contains several worksheets and I need to place a page number formula in a cell on the page rather than printing it as a header or footer command. I'm sure that this is possible but I'm not sure what the Macro or VBA code would look like or even where to place it.

    Thanks in advance for your help on this....Scott

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    14th January 2005
    Super Moderators

    Re: Page Numbering Formula


    Welcome to Ozgrid.

    I do not think there is a simple method without resorting to VBA.

    With VBA you could add a command button and write this behind it.

    Private Sub CommandButton1_Click() 
        Dim ws As Worksheet 
        For Each ws In Worksheets 
            ws.Range("a1").Value = ws.Name ' Enters Sheet Name in A1
            ws.Range("a2").Value = ws.Index ' Enters Sheet index in A2
        Next ws 
    End Sub 
    I added the name and number you could edit out the name if you don't need it

    and attached
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Last edited by carlmack; June 15th, 2006 at 02:41.

    Excel Video Tutorials / Excel Dashboards Reports

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Page Numbering Across Two Reports
    By abundant_lyfe in forum Excel and/or Access Help
    Replies: 2
    Last Post: June 26th, 2007, 01:25
  2. Page Numbering
    By JoshN in forum Excel General
    Replies: 6
    Last Post: March 19th, 2006, 12:00
  3. page numbering (again)
    By sginther in forum Excel General
    Replies: 12
    Last Post: June 25th, 2004, 00:39
  4. page numbering
    By sginther in forum Excel General
    Replies: 6
    Last Post: June 18th, 2004, 22:00


Posting Permissions

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