can be used a single cell for a range of consecutive values?!

Hello everybody,

I need to work with a big range of numbers... How can I input in a single cell a range of condecutive numbers, like from 1,50 to 10, with intervals of 0,01??? Then I would like to use this single cell in a complex formula, and extract the maximum value.

What I am trying to do is to not have to write a long serie of cells, each one with values like 1,50; 1,51; 1,52... up to 10,00... So I need some way to put all this in a single cell.


Thank you in advise!

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgxesLhWNr_zNP0GUdh4AaABAg. 9hI1CQJMLLo9hWn2pGBeSS
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgzkRujoMw9PblmXDQ14AaABAg. 9hJRnEjxQrd9hJoCjomNI2
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgzPZbG7OvUkh35nXDd4AaABAg. 9hJOZEEZa6p9hJqLC7El-w
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgwUcEpm8u6ZW3uOHXx4AaABAg. 9hIlxxGY7t49hJsB2PWxC4
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgyvDj6NWT1Gxyy2JyR4AaABAg. 9hIKlNPeqDn9hJskm92np6
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=Ugwy7qx_kG9iUmMVO_F4AaABAg. 9hI2IGUdmTW9hJuyaQawqx
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgxesLhWNr_zNP0GUdh4AaABAg. 9hI1CQJMLLo9hJwTB9Jlob
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgyyQWYVP1OnCqavb-x4AaABAg
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgwJKKmExZ1FdZVDJf54AaABAg
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=Ugz_p0kVGrLntPtYzCt4AaABAg
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg. 9h740K6COOA9iHOYYpaAbC
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgxuL6YCUckeUIh9hoh4AaABAg
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwGTEyefOX7msIh1wZ4AaABAg. 9h4sd6Vs4qE9h7G-bVm8_-
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

You could enter these values one below the other in a single cell by pressing ALT+ENTER for each new line. You must remember that there is a limit to the number of characters that a cell can contain. For Excel 2003, it is 32,767. Not sure what's for the latter versions.

Quote:

---

Originally Posted by Pinos

Hello everybody,

I need to work with a big range of numbers... How can I input in a single cell a range of condecutive numbers, like from 1,50 to 10, with intervals of 0,01??? Then I would like to use this single cell in a complex formula, and extract the maximum value.

---

There may be a purely mathematical solution to obtain your maximum value, but in order to know if that is the case, we need to see your complex formula.

An ugly way of getting there.
Cell A1 has the starting number
Cell A2 has the end number
Cell A3 has the increment
Column B needs to be empty (free to use)
Result in cell E2

Code:

---

Sub FillNumsBetween()
    Dim rRange As Range
    Dim rFill As Range
    Dim dStop As Double
    Dim rCell As Range
    Dim lr As Long
    Dim temparr
    Application.ScreenUpdating = False
    dStop = Cells(2, 1)  '<----- End Value
    Set rFill = Cells(1, Columns.Count).End(xlToLeft)(1, 2)    '<---- Where it starts filling results
    Cells(1, 1).Copy rFill
    Range(rFill, Cells(Rows.Count, rFill.Column)).DataSeries _
            Rowcol:=xlColumns, Type:=xlLinear, _
            Step:=Range("A3").Value, Stop:=dStop
    lr = Cells(Rows.Count, 2).End(xlUp).Row
    temparr = Range("B1:B" & lr)
    Cells(2, 5) = Join(WorksheetFunction.Transpose(temparr), "; ")
    Application.ScreenUpdating = True
End Sub

---

I hope someone cleans this code up. For now it should help you.