rename all cell names but keep the formula

[Guest]

I want to change sales!XXX to salesledgers!XXX in an entire worksheet if i
use the edit and replace i.e. " find " = sales"! " replace " = salesledgers!
it does it BUT the cell referance is lost, I just want to alter the names NOT
the cell refference, is I an sure there is a way but it eludes me, anyone
help please.

thanks in anticipation steve

 

[Bob Phillips]

Why not just rename the worksheet, that does it automatically.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

thanks bob,

I have a workseet named saleslcontrol and most of the cells refer to
salesledgers, I want to change them to sales, renaming is not an option,
sorry if I was not clear in my first asking

many thanks

steve

 

[Bob Phillips]

Can't you change the worksheet name to salesledgers, then change it to sales
afterwards?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

I don't understand what "the cell reference is lost" means.

Maybe you could share your
original formula
the actual edit|replace parms
the formula after the edit|replace