Crusty

If you are deleting a complete row then you could set up a formula referring
to the cell above, (in A2 for example),

=A1

Now when you delete the row the formulae will update in line

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"crusty53" wrote in message
...
I have a group of numbers,I delete one number in the middle ,i want the
numbers
after that number to reduce by one so that numbers still run in order.How
do
I do this.Thanks in advance .