Create range by adding one

[atuljadhavnetafim]

Hi Expert

I want to create Range Min and Max number up to certain count.
as per below table, K2 has number to which range to be create (here 11)

the number will be start from 2231000219 and end with 2231000229 (total 11 numbers)

the same range to be create in L column for 64 numbers, it start from 2232200747 and end with 2232200810

is there any formula which create range starting from row 3 and end up to row 4.

 

[jolivanes]

Not with a requested formula but with a short macro instead.

Sub With_A_Code_Snippet()
Dim i As Long
Application.ScreenUpdating = False
    For i = 11 To Cells(1, Columns.Count).End(xlToLeft).Column
        With Cells(6, i).Resize(Cells(2, i))
            .Formula = "=R3C+Row()-6"
            .Value = .Value
        End With
    Next i
Application.ScreenUpdating = True
End Sub

 

[atuljadhavnetafim]

will this work for all columns? like column K to T?

 

[atuljadhavnetafim]

it works as requirement
thanks

 

[Fluff]

Another option with a formula

=SEQUENCE(K2,,K3)