Printing A Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Bob,
How about...

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

Regards,
Jim Cone
San Francisco, CA
 
Back
Top