+ Reply to Thread
Results 1 to 2 of 2

UDF with Intersect in conditional formatting crashes excel during print preview

  1. #1
    Registered User
    Join Date
    08-19-2016
    Location
    Croydon
    MS-Off Ver
    2010
    Posts
    1

    UDF with Intersect in conditional formatting crashes excel during print preview

    Hi all,

    I have a user defined boolean function that calls the intersect command. When I use it in a cell to return the value TRUE or FALSE it works fine and I can print the sheet. When I use the same formula within conditional formatting to determine whether to highlight a cell it works fine on screen but when I try to print preview excel crashes. When I do quick print it also crashes. If I take intersect out of the UDF it works fine. Has anyone got any idea why this is happening?

    I have attached a simple demonstration of the problem.

    Thanks,

    Sam
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: UDF with Intersect in conditional formatting crashes excel during print preview

    No ideas, yet, but I will add these observations:

    1) I can get into Print Preview mode just fine. Excel only crashes when I try to exit print preview and go back to normal mode.
    2) I can go to the View menu and toggle back and forth between the Normal, Page Layout, and Page Break Preview views as much as I want, without crashing.
    3) When I tried to print to pdf using my pdf printer, Excel crashed, but the pdf printer created the pdf file just fine.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Conditional Print Preview a number of worksheets
    By Impjegat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2013, 08:22 AM
  2. excel 2010 crashes when printing and print.preview Macro
    By zmhnk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-08-2012, 09:24 AM
  3. Excel 2010 print/print preview error for combo boxes
    By dlmcdan in forum Excel General
    Replies: 3
    Last Post: 03-23-2011, 12:32 PM
  4. 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
  5. [SOLVED] In Excel, my color formatting is only showing in print preview. Fi
    By Cookie in forum Excel General
    Replies: 1
    Last Post: 03-12-2006, 10:35 PM
  6. Replies: 2
    Last Post: 11-07-2005, 05:10 AM
  7. [SOLVED] 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
  8. Trendline formatting doesn't print or preview properly!?
    By Graham Wideman in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-04-2005, 08:06 PM

Tags for this Thread

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