Try:-

In A1 =ROW(A1)

Drag down and delete a row and see what happens.

Mike

"shaji" wrote:

sir,

In my range of data, the first column is of serial number where in I put 1
in A1 and use the formula A1+1 in A2 and copying the same downwards. It
works perfectly unless I delete a row the range. When I delete a row #REF!
will appear in the remaining rows. Is any way to avoid this, i mean , when I
delete a row the formula should catch the number in the above row +1 in the
next.

please help