View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Auto update row numbers after inserting new row

You have replies at your posting in other new group.

Please don't multi-post.


Gord Dibben MS Excel MVP

On Mon, 26 Jan 2009 08:55:01 -0800, carusso
wrote:

Hi Fred, thanks for your repsonse. I already tried the =row(), but that still
won't automatically update row numbers if a new row is inserted between 2
existing rows. The user would have to know to copy down the formula after
inserting the new row....and most of these users don't have a clue what to do
in Excel... ;-)

Cheryl