View Single Post
  #1   Report Post  
Nexan
 
Posts: n/a
Default Repeating number sequence in a column

Is there a way to automatically set up a repeating number sequence in a
column? I've figured out how to do it with sequences of up to 7 numbers using
nested "IF" formulas in a macro, but as I understand it, that's as many
nested formulas as Excel can handle. I'd need repeating sequences up to three
digits in some cases.

Thanks!