It's interesting that it behaves differently depending on the starting
point...

In the context of my response to the OP, any entire row deletion(s) within
the formulated range, ie within B2:Bx itself will not disrupt the numbering.
It'll auto-adjust.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---