Loading Range Text Values to a Variant Array

[Buku09]

Hi All,

Hopefully this is an easy one, any help much appreciated.

I am trying to save a selected range to a variant array. Because I'm working with date and time formatted cells, I'm more interested in the Text property of these cells rather than Value. The following bit of code works fine but as soon as I replace .Value with .Text, the line returns an empty array.


Dim Results as Variant
Results = Worksheet("Sheet1").Range("A1:C100").Value 'would like to be able to return the Text property of cells here.

Thanks,

Buku