Trouble with variant used with range.text

[jameserenshaw]

Hi,

I'm having trouble with a variant when assigned the text values of a range. The piece of code I'm testing is below:

Dim RecordRows As Variant
RecordRows = Range("A7:AB46").text
MsgBox (RecordRows(2, 1))

It gives me a type mismatch error, which is odd considering a variant should be able to handle any data type. But if I use 'RecordRows = Range("A7:AB46").value' then it works fine. Only problem is that I need exactly what is in the cell, not the value. Having the value will cause me lots of checking, changing and general headaches.

Any help would be appreciated.

Thanks,

James

 

[RoryA]

The Text property won't return an array. It will return a String if all the cells have the same content, or Null otherwise. Either way, you'll get a type mismatch when you try and use it as an array.

 

[jameserenshaw]

Thanks,

Not the answer I wanted, but at least I know why it's not working now. I guess I'll have to check everything once it's come through.

Thanks again.