PDA

View Full Version : Solved: Code for printing.



nepotist
04-20-2009, 07:10 AM
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
04-20-2009, 08:48 AM
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$2"
.Orientation = xlLandscape
.FitToPagesWide = 1
.FitToPagesTall = False
End With


Paul

nepotist
04-20-2009, 01:30 PM
thanks..