Mark - Autonumber (One more thing...)

Posted by Jeremy on January 12, 2001 12:57 PM

Mark,
You had given me the following formula to calculate an autonumber.

ActiveCell.FormulaR1C1 = "=SUM(OFFSET(Sheet1!RC,-1,),1)"

It worked great! One more question, though. Is there a way to format the formula so that every time the autonumber reaches 999, it starts over at 1 instead of going to 1000?

Posted by Mark W. on January 12, 2001 1:21 PM

ActiveCell.FormulaR1C1 = "=IF(OFFSET(RC,-1,)&LT;&GT;999,SUM(OFFSET(RC,-1,),1),1)"

Posted by Jeremy on January 12, 2001 1:26 PM

PERFECT!! Thanks!