View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default Auto Fill Series when number ends in -1

Hi JGus,
in A1 =900000823 + Row() & "-1"
then fill down

If you need to start in some other cell, say C10 then use

in C10 =900000824 + Row() -ROW(B$10) & "-1"

the - ROW(B$10) can actually refer to any cell in row 10 but you must
put the $ sign before the 10. Also 900000824, not 900000823 in the
starting cell.

Ken Johnson