View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_44_] Bob[_44_] is offline
external usenet poster
 
Posts: 6
Default 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