Passing a range into a VBA function

[Floyd]

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.

 

[Jim May]

Set Rng1 = Range(NamedCell)

must be:

Set Rng1 = Range("NamedCell")

HTH

 

[Floyd]

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.

 

[Tim Williams]

Set Rng1 =NamedCell

tim

 

[Floyd]

Mr. Williams,

That worked perfectly.

Thank you.