Pr4int Preview Vs Print

[lar48ry]

I have a print macro that has worked very well until now. The problem
that I am encountering is that when I run the macro it will only show
the first 17 rows and then will overlay all the .jpg images on top of
each other and no rows after that, However, when I use Excel's Print
Preview function it shows all the rows with all the desired
information.

Also, when I use thie macro to actually print it prints exactly what
the preview showed. The same is true when using Excel's print function.

I am hoping that someone can shed the Light of Reason on this
situation.

Thanks

[Salad]

lar48ry wrote:

I have a print macro that has worked very well until now. The problem
that I am encountering is that when I run the macro it will only show
the first 17 rows and then will overlay all the .jpg images on top of
each other and no rows after that, However, when I use Excel's Print
Preview function it shows all the rows with all the desired
information.

Also, when I use thie macro to actually print it prints exactly what
the preview showed. The same is true when using Excel's print function.

I am hoping that someone can shed the Light of Reason on this
situation.

Thanks

I doubt it's your macor that is the problem. I would suggest it is the
report.

Has it been changed recently?

Sometimes if something gets hosed I simply create a new form/report and
then I copy paste all the fields for all of the bands into the new form
or report and then drop in the code and then rename the form/report to
the hosed on and replace it.