I am baffled, for some reason the following lines in the immidiate
window

? Excel.Union(Range("$A$1:$M$88"),Range("$A$1:$Z$2") ).AddressLocal

Outputs:

$A$1:$M$88,$A$1:$Z$2

Which is a Range with two Areas. I was expecting $A$1:$Z$88, which is
what I need. How would I make sure that Union only returns Ranges with
a single Area?

Thanks,
Daniel