passing range from RefEdit control

[Greg]

Hi,

I'm getting error in the following code:
'________________________
Dim rngX As Range, rngY As Range

Set rngX = RefEdit_inputx.Value
Set rngY = RefEdit_inputy.Value
'_________________________

What am I doing incorrect?
Appreciate your help.

--
______
Regards,
Greg

[Doug Glancy]

Greg,

Try:

Set rngX = Range(RefEdit_inputx.Value)

hth,

Doug


"Greg" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'm getting error in the following code:
> '________________________
> Dim rngX As Range, rngY As Range
>
> Set rngX = RefEdit_inputx.Value
> Set rngY = RefEdit_inputy.Value
> '_________________________
>
> What am I doing incorrect?
> Appreciate your help.
>
> --
> ______
> Regards,
> Greg