Find and Replace
 

Hi,
Can someone check my code here. It works on Excel 2003 but it will no
work on Excel 2000. Any clues?


Columns("P:P").Select
Selection.replace What:="-", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False



Thanks in advanc

--
jcc3
-----------------------------------------------------------------------
jcc31's Profile: http://www.excelforum.com/member.php...fo&userid=2469
View this thread: http://www.excelforum.com/showthread.php?threadid=49108

Find and Replace
 

I keep on forgetting that I can do a record and solve it that way.
Anyway, this is was I got.


Columns("P:P").Select
Selection.Replace What:="-", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

It work fine on Excel 2000


--
jcc31
------------------------------------------------------------------------
jcc31's Profile: http://www.excelforum.com/member.php...o&userid=24692
View this thread: http://www.excelforum.com/showthread...hreadid=491083

Find and Replace
 

Hi Jcc31,

The SearchFormat and ReplaceFormat arguments are not available in xl2k, so
delete these. I believe that these additional arguments were introduced with
xl2002.


---
Regards,
Norman


"jcc31" wrote in
message ...

Hi,
Can someone check my code here. It works on Excel 2003 but it will not
work on Excel 2000. Any clues?


Columns("P:P").Select
Selection.replace What:="-", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False



Thanks in advance


--
jcc31
------------------------------------------------------------------------
jcc31's Profile:
http://www.excelforum.com/member.php...o&userid=24692
View this thread: http://www.excelforum.com/showthread...hreadid=491083