Thread: union of named ranges based only on the names of those ranges
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
sloth sloth is offline
external usenet poster
  
Posts: 26
Default union of named ranges based only on the names of those ranges
Thanks Peter. I did that and it appeared to work, but when I tried to
assign the new name range (data) to a range variable (rng1) I got the
following error:

Method 'Range' of object '_Global' failed

Any thoughts?

Reply With QuoteReply With Quote