ExcelBanter - VBE Find and replace with pattern

Thanks, will give that a try.

RBS

"Daniel.M" wrote in message
...
Hi,

I'm assuming you know how to get each line of the VBE code.

Get Harlan Grove's SUBST() function == look into the Google archives and
recuperate the latest version.

Then for each line,

newText = SUBST(oldLine,"(.*) = True","$1")

Regards,

Daniel M.

"RB Smissaert" wrote in message
...
Is it possible to do a find and replace in the Excel VBE with a pattern
specified?
For example I would like to replace:
If bConditionA = True with:
If bCondition
I can do a find with pattern like this:
If * = True
But replace like this doesn't seem possible.
Thanks for any advice.

RBS