COleSafeArray

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone have a guess as to why you have to dimension the COleSafeArray with DIMENSION = 2 in order to read a column from a worksheet using the Range object? Seems like column data should be a single dimension, but COleSafeArray refuses to copy the VARIANT parray unless it is created with 2 dimensions.
 
a column when placed in an array directly is two dimensional = (1 to # of
rows, 1 to 1)

--
Regards,
Tom Ogilvy

chelms said:
Anyone have a guess as to why you have to dimension the COleSafeArray with
Click to expand...
DIMENSION = 2 in order to read a column from a worksheet using the Range
object? Seems like column data should be a single dimension, but
COleSafeArray refuses to copy the VARIANT parray unless it is created with 2
dimensions.
 
Back
Top