automatic number genaretion

[arnab0711]

HI,
is there a way,where excel is going to genarate numbers automatically from a given series.like if I give a starting number as 1 and ending number as 100 it will give me the inbetween numbers like 2,3,4,5,6,7,8,9,10,11..............91,92,93....99 and so on.

[pike]

hi arnab0711
use =randbetween(1,100)

[Armando Montes]

Insert this function in a module:
'http://www.vbaexpress.com/forum/showthread.php?t=26446

Function TextSplit(rCell As Range)
Dim l As Long
Dim r As Long

l = Left(rCell.Value, WorksheetFunction.Find("-", rCell.Value) - 1)
r = Right(rCell.Value, Len(rCell.Value) - WorksheetFunction.Find("-", rCell.Value))

For x = l To r
If x <> r Then
TextSplit = TextSplit & x & ","
Else
TextSplit = TextSplit & x
End If
Next x

End Function

'=TextSplit(A1)

[martindwilson]

with a function
put lower limit in b1 upper limit in c1
in a2 put =B1+1
in a3 dragged down as far as you like
=IF(ROW(A1)<$C$1-$B$1-1,A2+1,"")