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

alter your entries to formulas similar to this

="this is text " & Sheet3!A1 & " more text"

then in sheet3!A1 put what you want to display: (Name) or BoB

Sheet3 can be hidden if you wish.

--
Regards,
Tom Ogilvy



"jhahes" wrote:


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 replaced
with Bob.

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

thanks for any help

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=566792

Hi Tom,

thanks for the solution....it works....however

on some of the cells - it has errors because the text is more than 255
characters and it says formula is too long....Is there an easy way to
get around this?


thanks

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=566792

Well, you could put sections of that long text on cells on that Sheet3 and
then cocatenate them in

=Sheet3!A1 & " " & sheet3!A2 & " " & Sheet3!A3

perhaps.

or you can go back to your original and try doing Edit=Replace
What (Name)
With Bob

(with the macro recorder on if you want code).

It seems to me that replace also has problems with long text strings - as I
recall.

--
Regards,
Tom Ogilvy


"jhahes" wrote in
message ...

Hi Tom,

thanks for the solution....it works....however

on some of the cells - it has errors because the text is more than 255
characters and it says formula is too long....Is there an easy way to
get around this?


thanks

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=566792

Thanks, tom for helping me... i will try one of those


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=566792