is there a way to correct a word and automatically have excel correct all the formulas linked to that cell?

[bleeet]

i made a mistake and spelled a word wrong is there a way to correct this and have all the cells connected to this cells automatically change to the correct spelling i put?

 

[Ruddles]

Re: is there a was to correct a word and automatically have excel correct all the formulas linked to that cell?

What is this word? A folder on your hard disk, a workbook name, a worksheet name, a named range, a value in a cell, something in a formula, something in your VBA code... what does the word refer to?

 

[pagrender]

If it is just text, you may be able to use Find/Replace (Control + H) and Replace All.

 

[bleeet]

Re: is there a was to correct a word and automatically have excel correct all the formulas linked to that cell?

What is this word? A folder on your hard disk, a workbook name, a worksheet name, a named range, a value in a cell, something in a formula, something in your VBA code... what does the word refer to?

it's on a pull down menu and when selected activates if statement formulas in other cells

 

[Ruddles]

Find/Replace will look inside formulae. Click the Options>> button.

 

[bleeet]

thanks guys