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?

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?