Thread: print copies of the same sheet with changing values in a box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kaak[_67_] Kaak[_67_] is offline
external usenet poster
  
Posts: 1
Default print copies of the same sheet with changing values in a box

For i = 1 to 40

Range("A1").value = i
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

next i


--
Kaak
------------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513
View this thread: http://www.excelforum.com/showthread...hreadid=555909

Reply With QuoteReply With Quote