+ Reply to Thread
Results 1 to 3 of 3

Vba code to start page numbers from current page (bottom of the pate right side)

  1. #1
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Vba code to start page numbers from current page (bottom of the pate right side)

    Dear members,

    I required vba code to enter page numbers start from current page to last page of document. Page number should start from 1 and want in Bottom of the page to right side.

    Thank you.
    Regards,
    Nandkumar S.
    ---------------------------------------------------------------
    Don't forget to Click on * if you like my solution.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Vba code to start page numbers from current page (bottom of the pate right side)

    You don't need VBA for this, all you need do is insert a PAGE field into the page footer. If the 'current page' is not the first page of the document, you will need to insert a Section break before it, unlink the footer from the previous Section, then insert the PAGE field and set it to start from 1. All this can be done via the std dialogues.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Vba code to start page numbers from current page (bottom of the pate right side)

    Yes macropod !! You are great.......

    I was trying to start page numbering from seventh page and was not unlinking the footer from previous section....Problem solved
    Thank you very much.
    Rep added.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA/Macro to detect a heading at the bottom of a page and create a page break
    By jdodz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2014, 07:16 PM
  2. [SOLVED] start from bottom, find first instance of "Page", paste copied range below it...possible?
    By fredderf81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-02-2013, 02:02 PM
  3. Start page numbers on 4th Page
    By Blake 7 in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2010, 04:38 PM
  4. [SOLVED] Format page number in excel footer to start at a specific page #
    By straitctrydncr in forum Excel General
    Replies: 3
    Last Post: 04-11-2006, 08:00 AM
  5. [SOLVED] How to print 2 Excel pages side by side on 1 printed page?
    By Kathy Install in forum Excel General
    Replies: 1
    Last Post: 09-29-2005, 01:05 PM

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