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.