replace each content linked together to a named range

[dvb_24]

Hi I'm using the following code that replaces within a formula any text following "cleaner*[...]" (i.e. cleaner*Sheet1!B2) so would like to consider the whole string as the string to be replaced. Normally the formalua also has other contents.

Please Login or Register  to view this content.

Is that possible?

[venkat1926]

from your replacement code it looks you are replacing cell containing "clearner" as part string the whole is replaced as blank.
if this is so the following will help

I also assume that cell with cleaner occurs only once then the macro wil work
if it occurs more than once and al of them are to be replaced then you have to use
do...loop and findnext.

Please Login or Register  to view this content.