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