View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Fingerhut[_3_] Eric Fingerhut[_3_] is offline
external usenet poster
 
Posts: 6
Default keeping a range a range object

I like assigning data kept in a range to a variant array where possible. I
see that when the range consists of only a single cell, the variant takes on
the value of the cell and does not become an array (which makes sense). I
just don't know how to keep it an array. Sample code below:

Thanks!

Private Function IDataStorageConnection_Connect() As Boolean
Dim v As Variant
v = DataRng <------ this ia an Xl data range
MemoryStorage.VariantArray = v
MemoryStorage.IMemoryStorage_PopulateMemory
End Function