Hi

I use this routine to convert trailing minus signs to “proper” minus signs. It worked fine as a macro. I then incorporated this into an add-in that I use to clean up imported numbers at work. Still fine. As I’ve added more code to this utility it has stopped working, but will still work independently as a macro. The problem seems to lie with the “Right” instruction. Does anybody know of any conflict issues with the Left and Right commands

The error I get is :
Compile error : Wrong number of arguments or invalid property assessment

For Each UsrRng In Selection
If Right(UsrRng, 1) = "-" Then
NewNum = Left(UsrRng, Len(UsrRng) - 1)
UsrRng.Formula = "-" & NewNum
End If
Next UsrRng

Massive thanks to anyone who can shed any light on this for me.

DJB