Sory folks,
Thanks for your responses, all useful
The original code is OK but for my silly mistake with rng2 twice
Should have been MyVar = union(Range("rng1"),range("rng2"))
I've pressed all the 'Yes' buttons
Cheers

"David" wrote:

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