Results 1 to 7 of 7

Print Selection Macro help

Threaded View

  1. #1
    Registered User
    Join Date
    01-17-2020
    Location
    Corvallis, OR
    MS-Off Ver
    2019
    Posts
    33

    Print Selection Macro help

    so what I am doing is trying to get a certain selection to print after something is entered into a box. I have tried a couple different variations and have come to this one:
    Sub PrintSomeCells()
    Range("F15:F17,G15:G17").PrintOut
    End Sub
    This kind of does what I want it to do to a point but I need it to print ONLY if G13 turns green(I already have the formula set up for this) and also to print on 1 page (currently F15-F17 print on 1 page and G15-G17 print on a second page)


    Any help would be much appreciated.
    Attached Files Attached Files
    Last edited by Jede; 02-14-2020 at 12:57 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro To Print Selection In Color + Landscape
    By djsouljah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2013, 10:54 PM
  2. Print a certain selection macro
    By mmcgrail in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2013, 10:11 AM
  3. A macro to force print selection to PDF
    By Clydie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2013, 09:32 PM
  4. Macro to print a variable selection
    By galegai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2013, 10:03 PM
  5. Macro to Print Selection
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2012, 04:49 PM
  6. Macro to Print Selection
    By luke_p in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2008, 12:19 PM
  7. Date, Cell Selection and Print Macro - Possible?
    By EinGutesBier in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-03-2008, 12:55 PM
  8. How do I print a selection of cells using a macro?
    By gussuffert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2005, 05:06 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