Thread: VBA Print code?????
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Duke Carey Duke Carey is offline
external usenet poster
  
Posts: 1,081
Default VBA Print code?????
very simplistic

Dim i As Integer

i = InputBox("How many copies")
ActiveSheet.PrintOut copies:=i


"Chris Watson" wrote:


Can anybody give me the VBA code for a command button that will print
the active worksheet and also give the user the option to select how
many.


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=525646


Reply With QuoteReply With Quote