Hi Guru's..
I am getting this runtime error

Method 'Range' of object '_Global' failed

Here is the code causing it:

Public Sub AddChartSheet()
Dim dataRange As Range
CAUSING ERROR ---> Set dataRange = Range(avgRange.averageRange.Text)
avgRange.Hide
....
End Sub

avgRange is the name of my UserForm, averageRange is the name of the RefEdit object. Concerning the scope of my variable, do I need to declare anything global?

Thanks!!