I'm creating a user form where it will push data to an Excel spreadsheet. I
will later link this spreadsheet to MS Access to do some reports.

I need to create a function where for each new line added to a the
spreadsheet, I need to create a unique ID (the row name will be "ID") a
little bit like the AutoNumber in Access.

Thanks in advance for the help.

AutoId = Application.Max(Activesheet.Columns(1)) + 1

--
__________________________________
HTH

Bob

"Stephan Leduc" <(E-Mail Removed)> wrote in message
news48AD15A-453E-4FBE-88A2-(E-Mail Removed)...
> I'm creating a user form where it will push data to an Excel spreadsheet.
> I
> will later link this spreadsheet to MS Access to do some reports.
>
> I need to create a function where for each new line added to a the
> spreadsheet, I need to create a unique ID (the row name will be "ID") a
> little bit like the AutoNumber in Access.
>
> Thanks in advance for the help.
>

You are Fantastic Bob.

Thanks

Regards

Stephan

"Bob Phillips" wrote:

> AutoId = Application.Max(Activesheet.Columns(1)) + 1
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Stephan Leduc" <(E-Mail Removed)> wrote in message
> news48AD15A-453E-4FBE-88A2-(E-Mail Removed)...
> > I'm creating a user form where it will push data to an Excel spreadsheet.
> > I
> > will later link this spreadsheet to MS Access to do some reports.
> >
> > I need to create a function where for each new line added to a the
> > spreadsheet, I need to create a unique ID (the row name will be "ID") a
> > little bit like the AutoNumber in Access.
> >
> > Thanks in advance for the help.
> >
>
>
>