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 |
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