Many people here will advise you NOT to merge cells, and you have
found one of the reasons why. Is there a particular reason for wanting
to do so?

I suppose you could use a fomula like:

=MAX(A$1:A1)+1

in A2 with the number 1 in A1, and copy this down.

Pete

On Nov 28, 10:25 pm, Greggers
wrote:
Hello,
(Using Excel 2007)
I have a column of numbers in a sequence, for example 1,2,3 up to 10.
If for example I merge the two cells with 5 & 6 in them, the 6 is lost and
the sequence is broken.
What formula could I use in each cell which would re-calculate the sequence
should further cells in the column be merged?
I have tried simple A1+1 etc formula, but with the lower cell reference lost
due to the merge, this type of formula fails.

Any suggestions please.

Many thanks