View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Floyd[_2_] Floyd[_2_] is offline
external usenet poster
 
Posts: 35
Default 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.