+ Reply to Thread
Results 1 to 5 of 5

Create a print macro that would automatically select print area?

  1. #1
    Ron de Bruin
    Guest

    Re: Create a print macro that would automatically select print area?

    Hi wastedwings

    Can you give more information


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


    "wastedwings" <wastedwings@discussions.microsoft.com> wrote in message news:53BCEC4F-1E05-46D6-B5A3-25D208913B1F@microsoft.com...
    > How do I create a macro to automatically select the print area that has
    > contents in certain cells?




  2. #2
    wastedwings
    Guest

    Re: Create a print macro that would automatically select print are

    I have a worksheet that contains information that updates from another
    worksheet (contains links). I print the worksheet out each time it is
    updated, but I would like to create a macro that would automatically select
    the print area of the cells that contain information, instead of going in and
    selecting the print area. Since there are cells that do not have information,
    but contain links to another worksheet for future linking, hitting the print
    button will not print the cells that contain information only, but will only
    print a portion of the worksheet.

    "Ron de Bruin" wrote:

    > Hi wastedwings
    >
    > Can you give more information
    >
    >
    > --
    > Regards Ron de Bruin
    > http://www.rondebruin.nl
    >
    >
    > "wastedwings" <wastedwings@discussions.microsoft.com> wrote in message news:53BCEC4F-1E05-46D6-B5A3-25D208913B1F@microsoft.com...
    > > How do I create a macro to automatically select the print area that has
    > > contents in certain cells?

    >
    >
    >


  3. #3
    wastedwings
    Guest

    Create a print macro that would automatically select print area?

    How do I create a macro to automatically select the print area that has
    contents in certain cells?

  4. #4
    Ron de Bruin
    Guest

    Re: Create a print macro that would automatically select print area?

    Hi wastedwings

    Can you give more information


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


    "wastedwings" <wastedwings@discussions.microsoft.com> wrote in message news:53BCEC4F-1E05-46D6-B5A3-25D208913B1F@microsoft.com...
    > How do I create a macro to automatically select the print area that has
    > contents in certain cells?




  5. #5
    wastedwings
    Guest

    Re: Create a print macro that would automatically select print are

    I have a worksheet that contains information that updates from another
    worksheet (contains links). I print the worksheet out each time it is
    updated, but I would like to create a macro that would automatically select
    the print area of the cells that contain information, instead of going in and
    selecting the print area. Since there are cells that do not have information,
    but contain links to another worksheet for future linking, hitting the print
    button will not print the cells that contain information only, but will only
    print a portion of the worksheet.

    "Ron de Bruin" wrote:

    > Hi wastedwings
    >
    > Can you give more information
    >
    >
    > --
    > Regards Ron de Bruin
    > http://www.rondebruin.nl
    >
    >
    > "wastedwings" <wastedwings@discussions.microsoft.com> wrote in message news:53BCEC4F-1E05-46D6-B5A3-25D208913B1F@microsoft.com...
    > > How do I create a macro to automatically select the print area that has
    > > contents in certain cells?

    >
    >
    >


+ 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