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