Excel hanging problem

[rabs]

I need to set up a print area of a spreadsheet from the code. When I do this excel hangs in the Processes even after I close excel. I am using the following code:

.ActiveSheet.ResetAllPageBreaks
With .ActiveSheet.PageSetup
.PrintTitleRows = "$1:$2"
.PrintTitleColumns = "$A:$C"
End With

.ActiveSheet.PageSetup.PrintArea = _
"A1:" & ConvertColNumToLetter(GetLastCol()) & intFirstPageBrkRow - 1 & ",A" & intFirstPageBrkRow & ":" & ConvertColNumToLetter(GetLastCol() + 2) & intSecondPageBrkRow - 1 & ",A" & intSecondPageBrkRow & ":" & ConvertColNumToLetter(GetLastCol()) & "250"


Thanks to anyone who could help.

rabs

 

[Cbrine]

rabs,
Welcome to the board.

First thing is that setup is a little complex for setting a print range. I'm assuming you want to set up the print to print the entire worksheet. Here's the easiest way.
Don't set a print range, allow excel to figure it out for you. These three lines of code should take care of it for you, combined with your with statement.

.Zoom = False
.FitToPagesTall = False
.FitToPagesWide = 1

This will cause Excel to setup print settings as 1 page wide, and print the number of pages required based on the actual workbook itself.

HTH
Cal

 

[rabs]

Cal,

Thanks for the quick response. I must do the page setup at run time as the data size changes everytime I run it. The problem is when I do the PageSetup at run time, Excel process is not killed entirely even when I close the object. Just wondering if there is a work around to this problem.

Thanks in advance.

Rabs

 

[Cbrine]

Are you accessing excel from VB? or is this a vba macro?

The code I posted on the last post, will setup the printing so that excel will print correctly, I can't explain it very well in a post, but give it a try.
I think you are running into the crash because of something you are doing in the complex statement to define the print range.
If you want to print all populated cells in the worksheet, then my code will work great, without needing to define the print range.

HTH
Cal