Autonumbering

G

Gord Dibben

JE explains it as well as anybody but maybe what you are confused about is where
to place the varying sets of code.

All code except for Private Sub Workbook_Open() will go into a general or
standard module.

As JE points out, the Private Sub Workbook_Open() will go into Thisworkbook
module.

Depending upon which approach you take, there could be two of those.

For getting started with macros and VBA see David McRitchie's site.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

And Ron de Bruin's site for where to place codes.

http://www.rondebruin.nl/code.htm


Gord Dibben MS Excel MVP
 
V

VIVEKMANE

Dear Gord Dibben,
I cannot open the link which u have provided,
kindly explain..

Regards,
 
G

Gord Dibben

I provided two links and both work for me.

Which one does not open for you?


Gord
 
G

Gord Dibben

OP provided that link in his original post.

Obviously he had been there because he said he didn't understand John's code.


Gord
 
Top