ExcelBanter - Printing A Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Printing A Range (https://www.excelbanter.com/excel-programming/286465-printing-range.html)

Bob[_44_]

Printing A Range

Is there a way to print this range without page set up

If [I55] 0 The
Range("A52:I67").Selec
ActiveSheet.PageSetup.PrintArea = "$A$52:$I$67
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=Tru
ActiveSheet.PageSetup.PrintArea = "
End If

Jim Cone

Printing A Range

Bob,
How about...

Range("A52:I67").Select
Selection.PrintOut

Regards,
Jim Cone
San Francisco, CA

"Bob" wrote in message
...
Is there a way to print this range without page set up.
If [I55] 0 Then
Range("A52:I67").Select
ActiveSheet.PageSetup.PrintArea = "$A$52:$I$67"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveSheet.PageSetup.PrintArea = ""
End If

All times are GMT +1. The time now is 07:42 AM.