+ Reply to Thread
Results 1 to 3 of 3

Check Empty Cell Before Print Preview

  1. #1
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Check Empty Cell Before Print Preview

    Hello Friends,
    I want to check Empty cell before it goes to Print Preview....
    Currently it is checking empty cells but showing preview...

    Also, suggest changes for other structure if any...
    Attached Files Attached Files
    Don`t care, take care...

    Regards,
    Mangesh

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,485

    Re: Check Empty Cell Before Print Preview

    make use of the Cancel variable to determine whether to display or not

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Check Empty Cell Before Print Preview

    Yes... Its working perfectly... Thank you very much...

+ 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. [SOLVED] How to prevent "Print Preview" from slowing down your macros after viewing Print Preview
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2014, 02:54 PM
  2. VBA Macro shows Print Preview page: How to auto-maximize the Print Preview?
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2010, 04:48 PM
  3. Print Preview Doesn't Match Page Break Preview
    By mik7585 in forum Excel General
    Replies: 0
    Last Post: 06-01-2009, 11:32 AM
  4. Replies: 2
    Last Post: 04-05-2006, 09:40 PM
  5. [SOLVED] Cell Contents Cut Off in Print and Print Preview
    By Allison Orange in forum Excel General
    Replies: 0
    Last Post: 12-29-2005, 03:20 PM
  6. Excel cell looks good in print preview but doesn't print???
    By Jack Gathright in forum Excel General
    Replies: 1
    Last Post: 09-13-2005, 11:05 AM
  7. [SOLVED] Empty Print(preview)
    By Philip in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-27-2005, 10:05 AM
  8. Replies: 1
    Last Post: 05-26-2005, 05: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