| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Contigous Range from two ranges
I have two ranges:
$A$1 and $A$10 How do I bring them together to become a contiguous range. Union will create: A1, A10 I want A1:A10. Thanks EM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating Contigous Range from two ranges
Try
Set myrange = Range("A1:A10") Mike "ExcelMonkey" wrote: I have two ranges: $A$1 and $A$10 How do I bring them together to become a contiguous range. Union will create: A1, A10 I want A1:A10. Thanks EM |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating Contigous Range from two ranges
Yeah thats it. I got my wires crossed and assumed it was more difficult than
that. Thanks EM "Mike H" wrote: Try Set myrange = Range("A1:A10") Mike "ExcelMonkey" wrote: I have two ranges: $A$1 and $A$10 How do I bring them together to become a contiguous range. Union will create: A1, A10 I want A1:A10. Thanks EM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically creating Non-Contigous Ranges | Excel Programming | |||
| Creating a Range from two specified Ranges | Excel Programming | |||
| ListBox with non contigous columns | Excel Programming | |||
| XIRR with non contigous cells | Excel Worksheet Functions | |||
Linear Mode
