strAddress = Intersect(Range(Var1),Range(Var2)).Address(False,F alse)

HTH,
Bernie
MS Excel MVP


"XP" wrote in message
...
I am using Office 2003 on Windows XP.

My code dynamically returns certain contiguous columns and certain
continguous rows, say "C:E" and "5:10" for example, in two different
variables as string addresses.

I need to return the address of the intersection of these two ranges: C5:E10
Is it possible to do this without parsing the range addresses and without
actually changing the user's current selection? If so, could someone please
post a one or two line solution? I've been trying to use the "Intersect"
method without success.

Thanks much in advance.