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