VBA Bug with conditional formatting/printing?
 

Hi All,

I am trying to sort out a problem with conditional formatting not printing
correctly in a spreadsheet of mine. After posts on numerous groups and
forums with no answers, I tried everything I could think of to fix it, to no
avail. However, I have noticed something which I hope someone can explain
to me:

Lets say you have three sheets in a workbook with extensive conditional
formatting on +- 500 rows in each sheet. (Conditional formatting of borders
and shading depending on whether a cell contains data or not)

After entering data in the rows for each sheet, everything prints correctly
if you use File-Print Preview.

HOWEVER, if you use the immediate window in VBA editor to enter the
following commands, the formatting displays for only a portion of the
sheets. Why is this?

Sheets(Array("Result 1", "Result 2", "Result 3")).Select
Activewindow.Selectedsheets.PrintPreview

Any help or advice would be appreciated

Lawrence