Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need some ideas to develope a macro.
I have a large spreadsheet, and would like to print, then change a cell to
the next value on a list, and then print this spreadsheet, and continue until
all the items on the list have been used.
Any ideas
 
Sub Macro1()
For i = 1 To 20
Range("A1").Value = i
Application.Calculate
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Next
End Sub

The Calculate is in there just to be sure the print occurs after the dust
has settled.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro - Multiple printing 2
Run Macro If Cell have "x" value 0
Need help with simple macros for double checking manual plugs 4
macro to refresh from Access and then 2
Macro to loop through a list of items and print for each item 4
Make Macro Work On A Different PC 5
Data exchange between macro and spreadsheet 1
Macros 2

Back
Top