Hi All

Im trying to make the example 1 work from Copy3, but Im having trouble
referring to multiple named ranges - most I can get to work is one named
range (always only 1 [merged] cell). Whats the correct method?
- Set sourceRange = .Range("")

Also, is there a way to get the names of the ranges into row 1?

Thanks a heap
Andrew