Thread: Transfer Union(rng1,rng2) to variant array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
  
Posts: 1,560
Default Transfer Union(rng1,rng2) to variant array
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
Reply With QuoteReply With Quote