Thread: Creating a Range from two specified Ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PeterWilliams PeterWilliams is offline
external usenet poster
  
Posts: 1
Default Creating a Range from two specified Ranges

Hi, I want to create a range where the begin and end cells are specified
by two other Range variables. For example,

Set r1 = ActiveSheet.Range("C5")
Set r2 = ActiveSheet.Range("E8")

How can I define r3 to contain the range "C5:E8" using these two?

Thanks in advance.


--
PeterWilliams
------------------------------------------------------------------------
PeterWilliams's Profile: http://www.excelforum.com/member.php...o&userid=34438
View this thread: http://www.excelforum.com/showthread...hreadid=543547

Reply With QuoteReply With Quote