Hi
I am trying to create a macro that converts data on a worksheet. All o
that goes well but it says to use print preview to view results centere
horizontally on the page and a header and footer and that closes th
print preview and returns to the worksheet. When I test the macro al
of it runs great,but it stops on the print preview page and doesn't g
to the worksheet. I tried setting it up in page setup and then go t
print preview and back to the worksheet before I stop the macro but i
still stops at print preview page. I also tried putting the header an
footer in the print preview screen and that doesn't work either becaus
it stops at print preview when I test it. Any help would save me fro
pulling my hair out. Thank Yo

--
carmelcorn4

Posted from - http://www.officehelp.i