Transfer Union(rng1,rng2) to variant array
dim myVar as Range
Set MyVar = union(Range("rng2"),range("rng2"))
HTH
Bob
"David" wrote in message
...
Hi
I've tried:
dim myVar as variant
MyVar = union(Range("rng2"),range("rng2")).value but no joy so far
I'm just getting rng1 in the variant array
Both rng1 and rng2 are 12 x 1 ranges
Any ideas?
Thanks
|