email print area
 

I am able to email and save my print area. However when creating my form I
adjusted the row and column settings. When the attachment to the email
arrives the recipient views and prints 4 pages where the original print area
covered one 8.5"x11"page. The same thing occurs when viewing and printing
the saved copy.

Hi

Use Ctrl-End on the worksheet and see if it select you last cell with data.
If not see
http://www.contextures.com/xlfaqApp.html#Unused



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Raven506" wrote in message ...
I am able to email and save my print area. However when creating my form I
adjusted the row and column settings. When the attachment to the email
arrives the recipient views and prints 4 pages where the original print area
covered one 8.5"x11"page. The same thing occurs when viewing and printing
the saved copy.