Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use merge fields as in Word. Print sheets with 1 change
Want to print 52 copies of same sheet with only the change in data in one of
the cells (date). Used a drop-down list to change the cell but it still requires a lot of typing. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use merge fields as in Word. Print sheets with 1 change
Simple enough to dynamically change a cell for each printed sheet using a
loop - but you need to specify how the data is to change for each iteration. The following uses the iteration number (xCpy) to print the Week Number in cell A1 of the sheet........ Sub MultiPrint() Dim xCpy As Integer For xCpy = 1 To 52 Range("A1") = "Week Number " & xCpy ActiveWindow.SelectedSheets.PrintOut Copies:=1 Next xCpy End Sub -- Cheers Nigel "eaj" wrote in message ... Want to print 52 copies of same sheet with only the change in data in one of the cells (date). Used a drop-down list to change the cell but it still requires a lot of typing. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminate blank fields in mail merge from Excel to Word | Excel Discussion (Misc queries) | |||
how to NOT print an empty cell when I merge to Word doc? | Excel Discussion (Misc queries) | |||
Word found no merge fields in your main document. | Excel Discussion (Misc queries) | |||
Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) | |||
Print merge an Excel document with three worksheets to WORD Docume | Excel Programming |