Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need a macro that finds and replaces to repeat once it is run within the
same workbook, until it has found and replaced everything. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Why would you need to run it multiple times?
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "dpmac" wrote in message ... I need a macro that finds and replaces to repeat once it is run within the same workbook, until it has found and replaced everything. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Take a look at Find and FindNext methods in VBA help, or even the Replace
method. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "dpmac" wrote in message ... I need a macro that finds and replaces to repeat once it is run within the same workbook, until it has found and replaced everything. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro for multiple open files | Excel Discussion (Misc queries) | |||
Import a Code to a paragraph using a formula or macro! | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Executing multiple queries through a macro | Excel Discussion (Misc queries) | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |