Thread: Print Refedit range?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_638_] Leith Ross[_638_] is offline
external usenet poster
  
Posts: 1
Default Print Refedit range?

Hello,

Seet the print area to the RefEdit range before printing out the
worksheet.

With Worksheets("Sheet1")
..PageSetup.PrintArea = "$A$1:$C$5"
..PrintOut
..PageSetup.PrintArea = ""
End With

Change Sheet1 to match the name of the Worksheet the range is part of.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=558880

Reply With QuoteReply With Quote