| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where to find pattern fill add-in | Charts and Charting in Excel | |||
| Where to find pattern fill add-in | Excel Discussion (Misc queries) | |||
| How to find & delete a particular pattern of text from values of a | Excel Discussion (Misc queries) | |||
| Replace pattern of characters | Excel Discussion (Misc queries) | |||
| Wildcard pattern matching and replace in string | Excel Programming | |||
Linear Mode
