Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate the Excel VB Editor Find and Replace
Is it possible to write vba code that executes the Excel VB Editor Find and Replace function? If so how?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate the Excel VB Editor Find and Replace
There is no way to automate the full find and replace
functionality in the VBE. It doesn't support a Replace method. The CodeModule object does support a Find method, so you could use this to search for the desired text, use the Lines method to get the text, modify the text as required, use DeleteLines to delete the existing line and finally InsertLines to insert the modified text in to the CodeModule. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jtedge" wrote in message ... Is it possible to write vba code that executes the Excel VB Editor Find and Replace function? If so how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate the Find function in Excel | Excel Worksheet Functions | |||
automate replace values in formula | Excel Discussion (Misc queries) | |||
Need help find automate way to cross reference two GAINT excel databases!! | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
automate find & replace | Excel Programming |