VBA & Coding a dynamic range

[Mark Ivey]

I was wondering if anyone could help me out with some code issues.

I have found several links showing how to define a name range with VBA, but I would like to do so with a dynamic name range as well. Can someone help me with some generic code on this issue?

--
Mark Ivey

UoP e-mail: [email protected]
Personal e-mail: [email protected]

[Bob Phillips]

Set myRng = Range(Range("A1"),Cells(Rows.Count,"A").End(xlUp))
myRng.Name = "some_name"

which will get everytrhing in column A and name it "some_name"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mark Ivey" <[email protected]> wrote in message news:[email protected]...
I was wondering if anyone could help me out with some code issues.

I have found several links showing how to define a name range with VBA, but I would like to do so with a dynamic name range as well. Can someone help me with some generic code on this issue?

--
Mark Ivey

UoP e-mail: [email protected]
Personal e-mail: [email protected]

[Mark Ivey]

Thanks Bob. This works out great.

--
Mark Ivey

UoP e-mail: [email protected]
Personal e-mail: [email protected]
"Bob Phillips" <[email protected]> wrote in message news:[email protected]...

Set myRng = Range(Range("A1"),Cells(Rows.Count,"A").End(xlUp))
myRng.Name = "some_name"

which will get everytrhing in column A and name it "some_name"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mark Ivey" <[email protected]> wrote in message news:[email protected]...
I was wondering if anyone could help me out with some code issues.

I have found several links showing how to define a name range with VBA, but I would like to do so with a dynamic name range as well. Can someone help me with some generic code on this issue?

--
Mark Ivey

UoP e-mail: [email protected]
Personal e-mail: [email protected]