Excel application unloads while a process is on-going

  • Thread starter yayie via OfficeKB.com
  • Start date
Y

yayie via OfficeKB.com

Can you please help me, I am encountering problems using the PrintTitleRows ans PrintTitleColumns property of Excel. The Excel application unloads while a process is on-going. Here's my code:

With ActiveSheet.PageSetup
..PrintTitleRows = ""
..PrintTitleColumns = ""
End With
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
..LeftHeader = ""
..CenterHeader = ""
..RightHeader = ""
..LeftFooter = ""
..CenterFooter = ""
..RightFooter = ""
..LeftMargin = Application.InchesToPoints(0)
..RightMargin = Application.InchesToPoints(0)
..TopMargin = Application.InchesToPoints(1.38888888888889E-03)
..BottomMargin = Application.InchesToPoints(2.29166666666667E-02)
..HeaderMargin = Application.InchesToPoints(0.5)
..FooterMargin = Application.InchesToPoints(0.5)
..PrintHeadings = False
..PrintGridlines = False
..PrintComments = xlPrintNoComments
..PrintQuality = 600
..CenterHorizontally = True
..CenterVertically = False
..Orientation = xlPortrait
..Draft = False
..PaperSize = xlPaperLetter
..FirstPageNumber = xlAutomatic
..Order = xlDownThenOver
..BlackAndWhite = False
..Zoom = plngZoomValue
End With

After commenting the code for PrintTitleRows and PrintTitleColumns the problem does not anymore occur. I would like to know why it was the cause of problem.

Thanks a lot!Hope you can help me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top