| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
Using two ranges, rng1 and rng2, how can I define the range between them?
For example, if rng1 was B2 and rng2 was D10, then what formula can get me the range from B2  10Thanks in advance -- jake |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
MsgBox rng1.Resize(rng2.Row - rng1.Row + 1, rng2.Column - rng1.Column +
1).Address -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Jakobshavn Isbrae" <(E-Mail Removed)> wrote in message news:296A03D6-865E-4F82-9C96-(E-Mail Removed)... > Using two ranges, rng1 and rng2, how can I define the range between them? > > For example, if rng1 was B2 and rng2 was D10, then what formula can get me > the range from B2 10> > Thanks in advance > -- > jake |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Sub test()
Dim rng1 As Range, rng2 As Range, rng3 As Range Set rng1 = Range("B2") Set rng2 = Range("D10") Set rng3 = Range(rng1, rng2) rng3.Select End Sub Mike F "Jakobshavn Isbrae" <(E-Mail Removed)> wrote in message news:296A03D6-865E-4F82-9C96-(E-Mail Removed)... > Using two ranges, rng1 and rng2, how can I define the range between them? > > For example, if rng1 was B2 and rng2 was D10, then what formula can get me > the range from B2 10> > Thanks in advance > -- > jake |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Bob & Mike
Thank you both -- jake "Mike Fogleman" wrote: > Sub test() > Dim rng1 As Range, rng2 As Range, rng3 As Range > Set rng1 = Range("B2") > Set rng2 = Range("D10") > Set rng3 = Range(rng1, rng2) > rng3.Select > End Sub > > Mike F > "Jakobshavn Isbrae" <(E-Mail Removed)> wrote in > message news:296A03D6-865E-4F82-9C96-(E-Mail Removed)... > > Using two ranges, rng1 and rng2, how can I define the range between them? > > > > For example, if rng1 was B2 and rng2 was D10, then what formula can get me > > the range from B2 10> > > > Thanks in advance > > -- > > jake > > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Define a Range based on a Range object | Terry | Microsoft Excel Programming | 4 | 25th Oct 2010 08:44 PM |
| Hlookup problem in knowing what range to use | Hillary: needing some help | Microsoft Excel Worksheet Functions | 4 | 9th Oct 2008 10:18 PM |
| how to define range for autofill without knowing the last row . | =?Utf-8?B?VGVqaQ==?= | Microsoft Excel Programming | 0 | 7th Nov 2006 07:04 PM |
| fill in data range knowing start and end values | =?Utf-8?B?SnVsaWU=?= | Microsoft Excel Worksheet Functions | 1 | 11th May 2006 04:03 PM |
| Define a range based on another named range | =?Utf-8?B?QmFzaWw=?= | Microsoft Excel Worksheet Functions | 2 | 21st Feb 2005 01:47 PM |
