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" <[email protected]> wrote in message news:[email protected]...
>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.