Solved: Code for printing.

[nepotist]

Hello guys,

I have developed a tools in excel and everything went well with help from you guys. I need help with setting the print area options.

after my application creates out put I would like to set the print area as folows
the width should fit to one page and I have first two rows as heading for the out put and I would like to have this heading in every sheet of print out.

I dont know how to go about it. Can any one please help me with this

thank you

[Paul_Hossler]

[VBA]
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$2"
.Orientation = xlLandscape
.FitToPagesWide = 1
.FitToPagesTall = False
End With
[/VBA]

Paul

[nepotist]

thanks..