ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   passing range from RefEdit control (https://www.excelbanter.com/excel-programming/359665-passing-range-refedit-control.html)

Greg

passing range from RefEdit control
 
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

passing range from RefEdit control
 
Greg,

Try:

Set rngX = Range(RefEdit_inputx.Value)

hth,

Doug


"Greg" wrote in message
...
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





All times are GMT +1. The time now is 06:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com