Edit my Macro

[Gerard Sanchez]

Question:

'This macro selects, highlights, and print range A18:I69;
'I want to do away with highlighting the specified range and just
immediately print range A18:I69.

Sub PrintBatch()
'
' PrintBatch Macro
' Prints Each Batch
'
Range("A18:I69").Select
Selection.PrintOut Copies:=1
End Sub


'Thanks!

 

[Joerg Mochikun]

Sub PrintBatch()
Range("A18:I69").PrintOut Copies:=1
End Sub

 

[Gerard Sanchez]

It worked !

Thank you !!

Sub PrintBatch()
Range("A18:I69").PrintOut Copies:=1
End Sub

 

[Michael Bednarek]

It worked !

Thank you !!


"Joerg Mochikun" wrote

Write 500 times: "I will never ever use .Select in VBA code."