"Bob Reynolds" wrote in message ...
Thanks Mike, that took care of the save. However I need it to save the file
as it went to printpreview. When I've entered data I use the "find last row"
to determine the last row data was entered into and the print preview allows
me to print it whether it is one or eight pages. I need to actually save the
worksheet looking just like the page printed.

with the routine state above, it does a print preview and then I have to
close it and then the save box comes up.. it save the entire worksheet, all
eight pages of it. Any suggestions, not that my spelling was fixed.....
Thanks
BOB

Bob, as I understand Excel... when you save you save "it all" you
can't save a
sheet only...theres no point. PrintPreview will show you whats on a
worksheet regardless of determining the last line. You can play with
the "Print_Area"... and this can be manipulated with VBA. This will
limit what you see at PrintPreview. But all this has no effect on file
sizes etc. when saving.