Sub Macro3()
'
' Macro3 Macro
' Macro recorded 2/28/2006 by Dave
'

'
Selection.Replace What:=",", Replacement:=".", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
ActiveCell.Offset(0, 0).Range("A1").Select
End Sub


I just copied this macro from the recorder, insert it into a module and
assign a button to it,
highlite a range you want edited and then press the button


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517324