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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

C++ and Excel : Need Simple Charting Example (I can populate sheet with Data) 4
Problem passing a large safearray to Excel 2
Multi-Dimensional Array 17
Array Dim 6
Bargain Linux Pro pack 10 stickers £1 + free shipping 0
TESTING FOR EMPTY ARRAY 4
Populating a multi column listbox with ADO Recordset 2
How to find the Dimensions of a Variant Range 4

Back
Top