I have a string of addresses which i want to pass to the rng object. They
may not be in contiguous range form. So if I am in a position where I am
dong this:

Set rng = Range("A1,A3,A5,A7,A9,A10 etc")

What are the constraints without taking into account the Union function?

Note I will be using the Union function later but want to know the
constraints with it for the time being.

Thanks

EM

"merjet" wrote:

The method Union takes up to 30 arguments (Excel 2002).
Sample use: Set rng = Union(Range("A1:A5"), Range("D1:D5"),
Range("L1:L5"))

Hth,
Merjet