Passing a range into a VBA function
 

All:

I am attempting to pass a cell such as $C10 into a function. Inside
the function, I have the following code:

Dim Rng1 as Range
Set Rng1 = Range("$C10")

This code segment works. Now, if I attempt to pass a named cell into
the code, it compiles but gives the following error message when
"Watched". <Expression not defined in context Type = Empty

Dim Rng1 as Range
Set Rng1 = Range(NamedCell)

Any suggestions?

Thanks in advance.

Cheers.

Passing a range into a VBA function
 

Set Rng1 = Range(NamedCell)

must be:

Set Rng1 = Range("NamedCell")

HTH

"Floyd" wrote in message
oups.com...
All:

I am attempting to pass a cell such as $C10 into a function. Inside
the function, I have the following code:

Dim Rng1 as Range
Set Rng1 = Range("$C10")

This code segment works. Now, if I attempt to pass a named cell into
the code, it compiles but gives the following error message when
"Watched". <Expression not defined in context Type = Empty

Dim Rng1 as Range
Set Rng1 = Range(NamedCell)

Any suggestions?

Thanks in advance.

Cheers.

Passing a range into a VBA function
 

Mr. May,

I apologize. The range itself is not names. It is being passed as
reference with the name, NamedCell. For example, Function
Testing(NamedCell as range)

Thanks so much for your assistance.

Cheers.

Passing a range into a VBA function
 

Set Rng1 =NamedCell

tim


"Floyd" wrote in message
ps.com...
Mr. May,

I apologize. The range itself is not names. It is being passed as
reference with the name, NamedCell. For example, Function
Testing(NamedCell as range)

Thanks so much for your assistance.

Cheers.

Passing a range into a VBA function
 

Mr. Williams,

That worked perfectly.

Thank you.