View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Suzan
 
Posts: n/a
Default Sequential number - adding and deleting rows

Thanks! That is really going to help. Once again the board came thru. Love
you guys and gals!

/s

"Suzan" wrote:

Is there a way to squentially number a column so that if you insert or delete
rows in the middle the numbers will readjust? if you use A1+1 and copy it
down, you get a #REF if you delete; and a blank cell if you don't (and then
you have to use the fill handle from above the blank cell to resequence?

Any assistance would be greatly appreciated.

Suzan