something like this should work

Option Explicit
Sub test()
Dim cell As Range
Dim rng As Range
Set rng = Range("PrizePool")

For Each cell In rng
cell.Value = Replace(cell.Value, ",", "")
Debug.Print cell.Value
Next

End Sub

--


Gary


"TheIrishThug"
wrote in message
...

i need to make "1,458,685" into "1458685
i found Replace() on a website and assumed leaveing the last paramater
empty would work. it doesn't

this is what i was trying:
PrizePool = Replace(PrizePool, ",", "")


--
TheIrishThug
------------------------------------------------------------------------
TheIrishThug's Profile:
http://www.excelforum.com/member.php...o&userid=29682
View this thread: http://www.excelforum.com/showthread...hreadid=494444