excel

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

I need a formula for excel to autonumber a sheet as it is
saved as.
This is for a customer file which is used as an order
input suite.
Does anyone know how to do this

Frank
 
You need VBA

Private Sub Workbook_BeforeClose(Cancel As Boolean)
With Worksheets.Range("A1")
.Value = .Value + 1
End With
End Sub

Put this code in ThisWSorklbook code module

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Put this code in ThisWSorklbook code module
^^^^^^^^^^^^^^^

Bob
Interesting module name <vbg>

Frank
 
Don't you mean
DieselArbeitenmappel?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Bob!

I'll have the top half of the bottle!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Frank!

I'll have the top half of the bottle!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Bob!

No! It would be un-Australian if I didn't

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top