Jordan
Open the Visual Basic screen and enter the following:
---------------------
Sub IncByOne()
ActiveCell.Value = ActiveCell.Value + 1
End Sub
--------------------
This macro will increment the currently active cell by one each time it is
run. You can then assign a button to a custom taskbar, and this macro to
the button. By pushing the button at any time, the current cell value will
be incremented by one.
HTH
Mike Buraczewski
[log in to unmask]
-----Original Message-----
From: JORDAN FREEDMAN <[log in to unmask]>
To: [log in to unmask] <[log in to unmask]>
Date: Tuesday, January 12, 1999 1:22 PM
Subject: [PCSOFT] Autoincrement Macro
> I'm looking for an Excel 97 macro that would increment the numeric
> value in a cell by +1.
>
> Jordan Freedman
>
> Curious about the people moderating your
> messages? Visit our staff web site:
> http://nospin.com/pc/staff.html
>
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://nospin.com/pc/pcsoft.html
|