Xojo 2021 Release 1
I am trying to get an array from an excel range like this:
var ArrNr() as Variant
redim ArrNr(LastRow - FirstRow + 1)
ArrNr = WS.Range(“B” + sFirstRow, “B” + sLastRow).Value
redim or not, array is not filled while the vice versa way does work meaning I can fill a range from a Xojo array.
Trying with Collection I get error: “Array cannot be cast to Collection”.
Any idea what I missed?
dim VArrNr as Variant
gives back an OLEobject which TypeName is not shown nor do I know if this is available as Excel*-Type.
Any idea really appreciated!
(How does formatting code work???)