Quote Originally Posted by Aflatoon
Do you still have the same issue if you use:
[vba]
Dim fixstring As String
fixstring = sheets(1).range("A1").Text
fixstring = Replace(fixstring, "-","")[/vba]

Note: I would not really expect this to make a difference, but want to check.

Also, I assume it is definitely the first sheet that has the values you want?
Yes it is the first sheet that I am using, since it definitely recognizes the range, just not the correct number.

I won't be back until Tuesday, so i'll try the .text then. Any more suggestions are very welcome so I can try them all later haha