Mike,

Try changing

rows(m$1:m1018)-row(m1220)

to

rows(m$1:m$1018)-row(m1220)

which should increment as it is copied down the column.

HTH,
Bernie
MS Excel MVP

"MikeF" wrote in message
news:981282DD-5615-42A7-AE00- ... And so on.
I had tried something like rows(m$1:m1018)-row(m1220), but it always
returns
-2 as it goes down the rows, not -2, -3, -4, and so on.