Printing A Range

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
 
J

Jim Cone

Bob,
How about...

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

Regards,
Jim Cone
San Francisco, CA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA ERROR 2
Print two different areas on a worksheet 4
Print Code Help 5
Page Breaks in VBA Q 6
Printing Ranges 1
Printing 2
Change settings for print 1
VBA IF QUESTION 6

Top