Combining Named Ranges

Hi everyone,

I'm looking for a way to take 2 named ranges in a worksheet (that may have space between them) and create a third rectangular named range whose boundaries are the outer-boundaries of the initial 2 ranges. Union will not work because the third range must include any blank space between the initial 2 ranges.

Thanks!

Dave

Thanks, that was perfect!