I have a table that has four fields and 39k rows. The first field is for the sequential number. The fourth field has a different entry varing from the 177th to 185th row. Using VBA how can I seqentially insert a number from 1 to n based on the fourth field entry. Please help.