I have this simple lines
Code: Select all
Dim x as Integer
x=4
a = Evaluate("ROW(1:" & x & ")")
** Posted here too
https://chandoo.org/forum/threads/get-1 ... ate.42525/" onclick="window.open(this.href);return false;
Code: Select all
Dim x as Integer
x=4
a = Evaluate("ROW(1:" & x & ")")
Code: Select all
a = Application.Index(Evaluate("ROW(1:" & x & ")"), 0)
Code: Select all
a = Evaluate("COLUMN(" & [A1].Resize(, x).Address & ")")