+ Reply to Thread
Results 1 to 3 of 3

Macro for prining only pages witha specific cell populated?

  1. #1
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Texas
    MS-Off Ver
    Office 365
    Posts
    128

    Macro for prining only pages witha specific cell populated?

    I want to create a macro, that prints only pages with a certain box populated on the page. When I "Print Workbook". Is that possible? Basically I have a time sheet with 7 pages. 1 page for each day. I only want to print the pages that have a time entry in the first Row. Thanks in advance for any help. Just now getting into macros.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Macro for prining only pages witha specific cell populated?

    Hi HUNTXTRM,

    What you want is not difficult to do.

    In order for us to give you a quicker and more correct answer, you should probably upload a sample workbook formatted for the 7 pages and indicate what cell(s) you are interested in and what the values should be when you want to print.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Lewis

  3. #3
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Macro for prining only pages witha specific cell populated?

    Assuming you are interested on Range A1 value as time

    Try this code
    Please Login or Register  to view this content.
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

+ 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. Find last populated cell and subtract with specific value
    By arnejon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-14-2019, 06:15 AM
  2. print only populated pages
    By chriswrcg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-11-2017, 12:24 PM
  3. Replies: 0
    Last Post: 09-02-2014, 12:59 PM
  4. [SOLVED] Count specific value if another cell is populated
    By Ju1cy in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 07-03-2013, 11:41 AM
  5. please help me witha specific search option
    By meneses in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-30-2012, 11:53 AM
  6. [SOLVED] Print Macro to email PDFs of specific pages of a workbook to specific recipients
    By mike_vr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2012, 12:34 PM
  7. Capture only rows where a specific cell is populated.
    By cure4glass1 in forum Excel General
    Replies: 4
    Last Post: 06-05-2011, 11:15 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