Is there anyway to do the following...

Say I want to replace this

(name)

in every sheet with txtFirstName.value

for example

txtFirstName.value = "Bob"

So every sheet that has (name) in part of the cell will be replace
with Bob.

But when the worksheet closes put (name) back in and take out Bob.

thanks for any help

Jos

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=56679