Need to Redefine Range to include Additional Ranges

J

Jamie Carper

Hi,

I need to have a Range expand to include additional ranges.

e.g. Set MyRange = MyRange + YourRange

So that MyRange.Select will select the total area encompassed by the
prior two ranges.

I have tried Append, Join, Merge... these all seem to deal with the
contents of the ranges. Whereas I want to merge the ranges NOT the
cell values.

Any help please,

Jamie
 
Top