R Roland Nov 10, 2008 #1 is there a build-in function to merge 2 named ranges and give this a 3rd name
G Gary''s Student Nov 10, 2008 #2 Say we have two ranges named alpha and beta and want to merge them into something called gamma. Sub roland() Union(Range("alpha"), Range("beta")).Name = "gamma" End Sub
Say we have two ranges named alpha and beta and want to merge them into something called gamma. Sub roland() Union(Range("alpha"), Range("beta")).Name = "gamma" End Sub