Named Formulas

[Ken Fickling]

I need to slightly alter about 25 named formulas in a
book. They have a sheet reference by them which seems to
require that I alter them one sheet at a time. I have 5
sheets which are affected and just need these Named
Formulas to match all the others. Is there a way to
alter all of them at once? The changes are 'Index 2'
to 'Index' and 'Lstrow' to 'Lrow'. Same change for all
Named Formulas in all the affected sheets. Thx, KF

 

[Don Guillett]

try using find/replace or substitute macro