+ Reply to Thread
Results 1 to 3 of 3

Select current region and print

Hybrid View

  1. #1
    Tempy
    Guest

    Select current region and print

    Good day,

    I am filtering a form and only want to print the results of the filter.
    I have tried using current region to no avial, could somebody please
    assist with some code.

    Thanks,

    Tempy

    *** Sent via Developersdex http://www.developersdex.com ***

  2. #2
    Tom Ogilvy
    Guest

    Re: Select current region and print

    Range("A1").CurrentRegion.Printout

    Only visible rows will be printed

    0r

    Activesheet.Autofilter.Range.Printout


    --
    Regards,
    Tom Ogilvy

    "Tempy" <anonymous@devdex.com> wrote in message
    news:ObGJY$NRFHA.1096@tk2msftngp13.phx.gbl...
    > Good day,
    >
    > I am filtering a form and only want to print the results of the filter.
    > I have tried using current region to no avial, could somebody please
    > assist with some code.
    >
    > Thanks,
    >
    > Tempy
    >
    > *** Sent via Developersdex http://www.developersdex.com ***




  3. #3
    Tempy
    Guest

    Re: Select current region and print

    Thanks Thom

    Tempy

    *** Sent via Developersdex http://www.developersdex.com ***

+ 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