View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Return intesected range

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.