Losing conditional formatting when printing

  • Thread starter Lawrence Kritzinger
  • Start date
L

Lawrence Kritzinger

Hi,

I have a spreadsheet containing amongst others, 10 lists with conditional
formatting on every cell (e.g. border,pattern etc).

I use VBA code to print these lists but have noticed that when I print more
than 1 sheet, only the first few lines print with the con format displayed
onscreen.

I also noticed that the number of lines printed correctly correspond to the
number of lines in the first sheet i.e. if the first sheet contains 10 lines
and the second contains 20, only 10 lines on the 2nd sheet will print
correctly. If I have more lines on the 1st sheet than the 2nd sheet, all
lines on the 2nd sheet print correctly!

Is this memory related and if so, any suggestions for fixing it?

Thanks for any help.

Lawrence Kritzinger
 
Top