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
Bookmarks