Mark W. - Autonumber Question

Mark,

I may have misunderstood your posts, but I don't think they were exactly what I was looking for. I have a table that I have created that populates a database on the adjacent sheet using VBA. What I want is for every entry that I post to that database, for excel to assign an autonumber to that entry (this is exactly what Access does). I don't want to have to copy down numbers every time an entry is logged. I have left Column A open for this number. But want excel to do this automatically. Any suggestions?