It sounds like you are trying to use a spreadsheet as a database, can you
give me some more information about what you are doing and why you are doing
it in Excel?

If it's a case of having to use Excel for this but you need db functionality
then VBA is the way to go - but it's going to get messy if you have to code
for inserts, updates and deletes.

MH

"Trent Argante" wrote in message
...
Thanks MH.
I'm looking more for an internal sequential tracking number that's not
based on an in-cell formula. I need the sequential number to eventually
be hard-written to that row so that row deletion/insertion has no effect
on the sequential number assigned to a given row.
Trent Argante
[DC.J(510)]

*** Sent via Developersdex http://www.developersdex.com ***