I have the following questions
I) how can attribute the result from a query to an array?
works fine to output in a cell but I would need something among the lines
Dim myArr() As Variant
myArr <- rsData '<- attribution of values
II) I also would like to parameter the output of a query on a given range but the following gives me an error (propriety or method not available for this object)
Dim rng As Range
Set rng = Range(Cells(2, nbCol), Cells(2, nbCol))
I guess there is something with the range property I misunderstood. Any idea?