Thanks for the reply.

I want that the replaced reference for the cell should be like
1. what ever is before the function name i.e. GetValue should be removed.
- As you have added the comments, the things are working fine
2. what ever is there after the function name i.e. GetValue should be
appended as it is.
Now for each cell, the string after the function name is different.
say for B2 reference is
='C:\ExcelAddin\XLStart\ConsolidationAddin.xla'!ge tValue(B1,"OWNER","LINE_ITEMS",B12)
and for B3 the reference is
='C:\ExcelAddin\XLStart\ConsolidationAddin.xla'!ge tValue(B1,"EXTENDED_ACCOUNT_TYPE","LINE_ITEMS",B12 )

I want that within single find/replace, references should be replaced as
for B2 = getValue(B1,"OWNER","LINE_ITEMS",B12)
for B3 = getValue(B1,"EXTENDED_ACCOUNT_TYPE","LINE_ITEMS",B 12)

Please help.

Thanks,
Sandeep


"Stephane Quenson" wrote:

The Search And Replace feature supports wildcards. So press Ctrl-H, type
"*!GetValue(" (without the surrrounding quotes) in the "Find what" field,
"=GetValue(" (without the surrrounding quotes) in the "Replace with" field
and press "replace all" button.