Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: PRINT NON SEQUENTIAL PAGES

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can I build a macro that prints page 1 and 5 of a selection? (the printing menu only has the option to print FROM page x TO page y...)

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    To "build" this macro, do the following:

    Start recording
    Name your macro

    Select the print area for page 1
    Set the print area for page 1 on file menu
    Print it

    Select the print area for page 5
    Set the print area for page 5 on file menu
    Print it

    Stop Recording

    Have a nice day!
    Tom





    [ This Message was edited by: TsTom on 2002-04-02 02:44 ]

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How About:


    Code:
    Sub PrintIt()
    Dim strAdd As String
      strAdd = Selection.Address
           Sheets(1).Range(strAdd).PrintOut
           Sheets(5).Range(strAdd).PrintOut
    End Sub

    _________________
    Kind Regards
    Dave Hawley
    OzGrid Business Applications
    Microsoft Excel/VBA Training






    [ This Message was edited by: Dave Hawley on 2002-04-02 03:47 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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