I can take a named range such as DAT1
and change it to a variable then use it to say select
i.e. Set ab = Range("DAT9")
Set cd = Range("INT5")
cd.Select
but how do I use the variables in the next example

Set isect = Application.Intersect(Range("DAT5"), Range("INT5"))
I cant seem to figure this out
thanks

Set isect = Application.Intersect(ab,cd)

--

HTH

Bob Phillips

"Rod Taylor" wrote in message
.. .
I can take a named range such as DAT1
and change it to a variable then use it to say select
i.e. Set ab = Range("DAT9")
Set cd = Range("INT5")
cd.Select
but how do I use the variables in the next example

Set isect = Application.Intersect(Range("DAT5"), Range("INT5"))
I cant seem to figure this out
thanks

thanks
"Bob Phillips" wrote in message
...
Set isect = Application.Intersect(ab,cd)

--

HTH

Bob Phillips

"Rod Taylor" wrote in message
.. .
I can take a named range such as DAT1
and change it to a variable then use it to say select
i.e. Set ab = Range("DAT9")
Set cd = Range("INT5")
cd.Select
but how do I use the variables in the next example

Set isect = Application.Intersect(Range("DAT5"), Range("INT5"))
I cant seem to figure this out
thanks