Sub PutThemAway()
Dim str As String
str = MyRefEditControl.Text
str = Application.Substitute(str, "$", vbNullString)
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"FGM"
wrote in message
Is there a way to use Refedit Control and have it not return Absolutes.. $A$4?

I use Refedit to get a range and use it in a formula and it works great.
However, when I want to copy that formula to other cells it does not work
because of the $ absolute references.

Thanks in advance if you can help