samedi 28 février 2015

Convert 2 dimensional array to one dimensional (without Looping)

I found this worked well for an Excel Range, where the result would be array(n) notation instead of array(1, n) enter code here Result = Application.Transpose(Application.Transpose(Worksheets(kSheet).Range("Y20:AC20")))


However I have a result from .getrows which is array (n,0) notation. Can this be converted to arry(n) notation simialr to above ?


Aucun commentaire:

Enregistrer un commentaire