Using one or two dimensional arrays in Excel VBA -

Using one or two dimensional arrays in Excel VBA -

i have couple of basic questions using arrays in vba, have not found reply to.

firstly, there way specify 1 dimensional row vector in excel vba?

i new using arrays in excel vba, , have been defining row , column vectors 2 dimensional arrays, in examples below

'define local row vector redim aarray(1 icntrows, 1 1) 'define local column vector redim aarray(1 1, 1 icntcols)

so secondly, best practice? should using 1 dimensional array instead?

thanks tim

where intend re-create array range, like

range(somerange) = aarray

then , yes, utilize 2d arrays

arrays excel vba excel-vba vector