need help with macro

[danmen]

I have a workbook with five tabs one of which is called BASE DATA. I would like to change the word BASE DATA to SETUP. I'm looking for a macro that will seek and change all occurrences of the word throughout the workbook ( everywhere like cell formulae and vba coding and everywhere else ). Is there an easy way to do this?

thx. for any help!

 

[Weaver]

If you change the tab name yourself, all the formulas will update automatically (unless you've made use of the indirect() formula, which could potentially cause issues)

As for any vb, you could just use find/replace in your modules.

HTH

 

[GlennUK]

If your cell formulas are referencing this sheet directly, then renaming it will cause them to adjust automatically. As for macros, just do Edit/Replace on the whole project.

 

[danmen]

unfortunately I have a lot of indirect statements that will not change to the new tab name, is there any way to make it work? thx. again

 

[Blade Hunter]

Search and replace (CTRL-H) and choose to "look in formulas"?