YasserKhalil
Well-Known Member
Hello everyone
I have this simple lines
The code constructs an array (2D array) .. Is there a trick to get 1D Array using Evaluate?
I tried something like that but doesn't work for me
** The thread is posted here too
I have this simple lines
Code:
Dim x as Integer
x=4
a = Evaluate("ROW(1:" & x & ")")
The code constructs an array (2D array) .. Is there a trick to get 1D Array using Evaluate?
I tried something like that but doesn't work for me
Code:
a = Application.Index(Evaluate("ROW(1:" & x & ")"), 0)
** The thread is posted here too