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" wrote:

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)



"steve alcock" wrote in message
...
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