dansam
05-19-2007, 11:12 AM
Hi everyone :hi: ,
I have a little problem here :
I use the following code to make replacements in cells using macro :
Cells.Replace What:="Sample Text", Replacement:="Sample Text2", LookAt:=xlPart, SearchOrder _
:=xlByColumns, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
I works fine for me but how to select or get the address of the cell where the replacement has made. Any Idea ??
Help ! :think:
Best Regards,
Dan
I have a little problem here :
I use the following code to make replacements in cells using macro :
Cells.Replace What:="Sample Text", Replacement:="Sample Text2", LookAt:=xlPart, SearchOrder _
:=xlByColumns, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
I works fine for me but how to select or get the address of the cell where the replacement has made. Any Idea ??
Help ! :think:
Best Regards,
Dan