INVOICE NUMBER WITHOUT MC GIMPSEY'S PAGE

[Andreas]

Hello i can't find out the tutorial on:
Http://mcgimpsey.com/excel/udfs/sequentialnums.html -
So please help me in another way. I'm not the best in the american language
but please helt med without a difficult homepage about making a macro.

I can't find out making the macro, please help me step by step if that is
nassery!

Kind regards

 

[kassie]

Press <Alt> <F11> to go to your VB environment. On the left of the screen,
double click on <This workbook> under your workbook . Now go to Mr Mc
Gimpsey's page, block the entire section starting at Private Sub
Workbook_Open(), and go down to End Sub. Press <Ctrl><C>, go back to VBA,
click in the right hand window, and press <Ctrl><V>

 

[Andreas]

Allright kassie... It's done.....

But now i get a error sais:
Run-time error '9':
Subscript out of range

[End] [Debug] [Help]

And what can i do now?
Kind regards

"kassie" skrev: