ceegar wrote:

did you see the answer from JE McGimpsey in the other thread you started?

one way:

A1: =ROW()

Copy down as far as necessary.



Another way is 1 in A1 2 in A2 highlight both cells then drag
it from the right hand corner down the column.

gls858