delete certain text in a workbook
 

How would I create a macro to search through a workbook and delete all text
strings that are either "Created by 10-K Wizard." or
"http://www.10kwizard.com/" ?

The strings would be replaced by "" (i.e., nothing.)

Thanks.

Dave
--
Brevity is the soul of wit.

delete certain text in a workbook
 

In 2003 (not sure befoe) you can use the Edit, Find and replace all option
Check the options button and from the Within: dropdown select "Workbook"

"Dave F" wrote:

How would I create a macro to search through a workbook and delete all text
strings that are either "Created by 10-K Wizard." or
"http://www.10kwizard.com/" ?

The strings would be replaced by "" (i.e., nothing.)

Thanks.

Dave
--
Brevity is the soul of wit.

delete certain text in a workbook
 

Duh. That is remarkably simple and I'm embarrassed I overlooked it.

Thanks.

Dave
--
Brevity is the soul of wit.


"JMay" wrote:

In 2003 (not sure befoe) you can use the Edit, Find and replace all option
Check the options button and from the Within: dropdown select "Workbook"

"Dave F" wrote:

How would I create a macro to search through a workbook and delete all text
strings that are either "Created by 10-K Wizard." or
"http://www.10kwizard.com/" ?

The strings would be replaced by "" (i.e., nothing.)

Thanks.

Dave
--
Brevity is the soul of wit.