Here's a way using two helper columns.

1) in the first helper column, sequentially number every row.
2) sort the sheet so all the blank rows are at (say) the bottom
3) in the second helper column, sequentially number every row, apart from
the blank ones at the end
4) resort the sheet by the numbers in the first helper column
5) delete the first helper column, which leaves only the non-blank rows
sequentially numbered

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"AndrewRichardWood" wrote in
message ...
I simply want to sequentially number rows in a column. However, some of
the
rows do not contain any data so do not need to be numbered. So there is
in
fact a blank. It´s also possible that i´d want to add another row, and
auto
update the number sequence. You cannot drag the auto numbering facility
across cells that you want to remain empty of course, because they will be
numbered.