+ Reply to Thread
Results 1 to 4 of 4

Macro to print Sheets from BMD Sales to end, except those where B10 is blank

  1. 01-04-2021, 05:36 AM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,749

    Macro to print Sheets from BMD Sales to end, except those where B10 is blank

    I have written code to print all sheets from BMD Sales to last sheet


    I need the code amended so where B10 is blank on any of these sheets, then only to print those where B10 is not blank


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-04-2021, 06:01 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,279

    Re: Macro to print Sheets from BMD Sales to end, except those where B10 is blank 

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 01-04-2021, 06:18 AM #3
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,749

    Re: Macro to print Sheets from BMD Sales to end, except those where B10 is blank

    Many thanks sintek. Code works perfectly
    Reply With QuoteRegister To Reply
  4. 01-04-2021, 06:22 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,279

    Re: Macro to print Sheets from BMD Sales to end, except those where B10 is blank

    Pleasure...tx for rep +
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Print selected sheets and not print blank rows
    By MARD99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2017, 04:39 PM
  2. Simple macro to set print area for all the non-blank cells in many sheets
    By dhcwong in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-12-2017, 06:40 PM
  3. Print is printing out blank sheets for hidden rows
    By rousseauassociates in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2016, 08:45 AM
  4. Print sales bill from sales data
    By dhaval123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-26-2013, 06:56 AM
  5. Print Macro that can print one or both sheets of a workbook
    By 6423joel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2013, 10:18 AM
  6. Print checked worksheets with sheets own print macro
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2013, 10:35 AM
  7. Print command also printing blank sheets
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2011, 10:51 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1