Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add an auto number to a worksheet
Can I add an auto number to a work sheet
or a button to generate a number which increases by 1 each time. Office 2000 |
#2
|
|||
|
|||
You could create a macro and assign it to a button from the Forms toolbar
(placed on that worksheet). Option Explicit sub testme01() with activesheet if isnumeric(.range("a1").value) then .range("a1").value = .range("a1").value + 1 end if end with end sub peterm wrote: Can I add an auto number to a work sheet or a button to generate a number which increases by 1 each time. Office 2000 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
assign auto number and auto date | Excel Discussion (Misc queries) | |||
Create an Auto Number | Excel Worksheet Functions | |||
Auto Filter will not work in a new worksheet | Excel Worksheet Functions |