Asha, correct - no question is a dumb question.
Regards your first question concerning () in your variable declaration:
is explicitly declaring vArray1 as an Array - when you try to apply a single cell to this Array you get your Error.
Whereas:
would not error, however, vArray would either become:
a) a single value Variant
b) a Variant array (>1 item)
You can work around this issue - by testing the items in the Range as outlined by Pike or by testing the VarType of vArray once populated (ie Array or non-Array).
However, it is of course easier if you can always ensure the output is a Variant Array irrespective of whether or not you have 1 or > 1 items.
As illustrated you can do this using Evaluate (ie 1 to 1)
Regards your 2nd question...
To convert a single column range to a 1d array would warrant one transposition.
To convert a single row range to a 1d array would warrant two transpositions.
Apologies for not adding this to the original (untested) code.
Bookmarks