On Thu, 16 May 2013 11:14:52 +0200, Claus Busch
wrote:

Hi Robert,

Am Thu, 16 May 2013 02:06:06 -0700 schrieb Robert Crandal:

Just curious, but is it possible to specify that same range above
using other objects such as Cells(), etc?? It seems like Excel has
tons of ways to specify the same range.

the arguments for Intersect are ranges. You can specify 2 ranges up to
30 ranges. You can use all objects that returns a range.


Regards
Claus Busch


Just give it a name.

highlight the cell range in question, and place the cursor in the cell
address box (upper left corner)and TYPE the range name you want to give
it. from then on, a reference to that range name is ONLY that specified
range. In the new excel (not sure on older versions) you can click on a
drop down in the cell address box and any named ranges will be listed.
Clicking on one will take you there, and highlight it.