Thread: Camera Printing problem

Hi,

I have 8 cameras referencing cells on the same sheet, depending on the value in another cell (also on the same sheet) the camera's display different sets of cells (eg. A95:C101). Unfortunately as soon as I print, the cells being displayed get shifted out of position. The formula for each camera is basically the same, just referencing different cells, formula as follows:

=IF(Sheet1!$G$5=0,Sheet1!$J$143:Sheet1!$L$150,Sheet1!$A$133:Sheet1!$C$141)

Cells J143:L150 contain two lines forming a diagonal cross, cells A113:C141 contain an image of a diagram.

Anyone have any idea what the problem could be??

Thanks in advance!

Maximus