Hi Case250,
The RefEdit control Value is a text string address of the selected range. This can then be used by the Range property to yield a Range object, which can then be input to the Average worksheet function.
Here's an example line of code:
MsgBox "Average is " & WorksheetFunction.Average(Range(RefEdit1))
This pops up a message box displaying the average of the range selected in RefEdit box RefEdit1.
Keep Excelling.
Damon