Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to merge two ranges
I have
dim fields1, fildes2, fields3 as range i want to do set fields3=fields1+fields2 fields3.select how do i do this in code? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to merge two ranges
Hi,
When you dim ranges note how i've done it otherwise you range is dimensioned as Variant Dim fields1 As Range, fields2 As Range, fields3 As Range Set fields1 = Range("A1:A10") Set fields2 = Range("C1:C10") Set fields3 = Union(fields1, fields2) fields3.Select Mike "sunilpatel" wrote: I have dim fields1, fildes2, fields3 as range i want to do set fields3=fields1+fields2 fields3.select how do i do this in code? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge named ranges ? | Charts and Charting in Excel | |||
merge named ranges | Excel Worksheet Functions | |||
How to merge 2 ranges from to worksheets? | Excel Programming | |||
merge ranges | Excel Programming | |||
Merge ranges based on condition | Excel Programming |