Cell values of the selected range using RefEdit control in Excel 2007

[pvharibabu]

How do I get the cell values of the selected range using RefEdit control in Excel 2007?


I have a RefEdit control in an userform, used to select a range in a worksheet and want to use the cell values for my further calculations. Wondering how I get these values.

 

[shrivallabha]

Untested:


You can try a loop like:

[pre]

Dim rng as Range
For each rng in Range(Me.RefEdit1.Text)
msgbox rng.value
next rng
Or populate an array:

Dim aryData as variant
aryData = Range(Me.RefEdit1.Text).Value

[/pre]
and then use it in your code.

 

[pvharibabu]

Thank you!!!