Thread: print and save a single sheet from a workbook using a commandbutt.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sujata_ghosh[_5_] sujata_ghosh[_5_] is offline
external usenet poster
  
Posts: 1
Default print and save a single sheet from a workbook using a commandbutt.

hi,

try out the following

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

or if you want to print some selective part of the page

then use

for example:

Range("B9:M12").Select
Selection.PrintOut Copies:=1, Collate:=True


sujata


--
sujata_ghosh
------------------------------------------------------------------------
sujata_ghosh's Profile: http://www.excelforum.com/member.php...o&userid=16432
View this thread: http://www.excelforum.com/showthread...hreadid=277941

Reply With QuoteReply With Quote