I am importing a bunch of data, and the first field is Record #: I
want this field to increment with each imported record.
So the first line would be record 1, second line record 2 etc etc.
Anyone have some code that will do this?
I am importing a bunch of data, and the first field is Record #: I
want this field to increment with each imported record.
So the first line would be record 1, second line record 2 etc etc.
Anyone have some code that will do this?
As always, best to post your coding efforts but
cells(rows.count,"a").end(xlup).row+1
will give you the next available row
--
Don Guillett
SalesAid Software
[email protected]
"wmureports" <[email protected]> wrote in message
news:[email protected]...
>I am importing a bunch of data, and the first field is Record #: I
> want this field to increment with each imported record.
>
> So the first line would be record 1, second line record 2 etc etc.
> Anyone have some code that will do this?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks