Hi peyman

You can add this to the code beofre the print line

With ActiveSheet.PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = False
.Orientation = xlLandscape
End With




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"peyman" wrote in message ...
hi Ron,
when I use the macro, the print is made in two pages!! how can I set up the
print for one page.the columns A to H are in one page, I,J,... in the next
pages!!!

"Ron de Bruin" wrote:

Hi

Not possible manual

You can use a macro
http://www.rondebruin.nl/print.htm#non-contiguous

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"peyman" wrote in message ...
how can I print multiple selected rows in a page?!