View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
carusso carusso is offline
external usenet poster
 
Posts: 19
Default Auto update row numbers after inserting new row

I have a spreadsheet with Column A rows numbered sequentially using auto fill
series [have also tried Row()]. If someone adds a new row BETWEEN 2 existing
numbered rows (not after the last populated row), is there any way to have
the row numbers automatically renumber to include the new inserted row?
Thanks!
--
carusso