I think of only a small macro (perhaps other solutions may be available)
give a name to the range of nonadjacent cells e.g. rv
then use this macro

Sub test()
Dim c As Range
Dim j As Integer
j = 0
For Each c In Range("rv")
j = j + 1
c = j
Next
End Sub


"juikijui" wrote in message
...
How can I continue a series of Text and Number values if the cells are not
adjacent? The values would be something like: Text 1, Text 2 etc. I
need
to be able to change the cell containing Text 1 to Text 12 for example and
have all the other cells fill in sequentially, so that I would have Text
12,
Text 13 etc.