Yossi,

Unless you need the arguments after the MatchCase argument, you
can omit them. They apply only, I think, to Far East versions of
Excel. If you want to use all the arguments, use code like

#IF VBA6 THen
' Excel 2000 version of Replace
#Else
' Exce 97 version of Replace
#End IF


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Yossi Shalom" wrote in message
...
the code :
colum.Replace What:="c:\pikuhit\[1000.xls]",
Replacement:="c:\pikuhit\"
& year_taagid & "\[" & num_taagid & ".xls]", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False,
MatchControlCharacters:=False,
_
MatchDiacritics:=False, MatchKashida:=False,
MatchAlefHamza:=False

This is the code in 97.
Untill MatchCase, its the same.
If i run this code I get error.
When I change, it doesnt give error but do nothing.

Thanks


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!