software

When doing reports for school, i print several pages of the same each time
making changes. I have a date feild in the header to tell me the date i
printed it, but i would also like a function of code to autommaticly increace
by one. This would give me some idea of what coppies of my report came
first. This feature is sort-of a version number that updates on print. (or
on save depending on option)

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

A simple answer (which I use in a similar situation) which hopefully will
suffice.

Have a button that runs a macro to print but also moves the reference on by
1 each time. For example Cell A1 could hold the issue number - say 8 (the
last reference printed) - cell A2 is 1.The macro would move the reference on
by 1 and print.

Range(quot;B1quot;).Select
Selection.Copy
Range(quot;A1quot;).Select
Selection.PasteSpecial Paste:=xlAll, Operation:=xlAdd, SkipBlanks:=False _
, Transpose:=False
Application.CutCopyMode = False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Hope this helps.Andrew

quot;Power Computingquot; wrote:

gt; When doing reports for school, i print several pages of the same each time
gt; making changes. I have a date feild in the header to tell me the date i
gt; printed it, but i would also like a function of code to autommaticly increace
gt; by one. This would give me some idea of what coppies of my report came
gt; first. This feature is sort-of a version number that updates on print. (or
gt; on save depending on option)
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions

You could always just add a time field.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;Power Computingquot; lt;Power gt; wrote in
message ...
gt; When doing reports for school, i print several pages of the same each time
gt; making changes. I have a date feild in the header to tell me the date i
gt; printed it, but i would also like a function of code to autommaticly
gt; increace
gt; by one. This would give me some idea of what coppies of my report came
gt; first. This feature is sort-of a version number that updates on print.
gt; (or
gt; on save depending on option)
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions