Replace text within a formula?

[EconSean]

Greetings all.

I have multiple (20) worksheets, each with approximately 50 formulas. The formulas are all the same currently, in that they reference a particular sheet, call it Region 1. Now, I would like to be able to change this to Region 2, Region 3, etc, depending upon the worksheet that the formula is on.

I am unable to get the standard Edit - Replace to work with the formulas, as I get an "Unable to find match" message.

Anyone have any experience with this?

Thanks in advance for any help.

Kind Regards,

Sean

 

[PaddyD]

Hey Paddy, what red circle? I don't see one.

OK dumb question, what's a report post function?

..'cos I just discovered you can remove them too! Mouseover the ! icon - says something like "report this post" - click it & it sends a pop-up / mail to any (all??) moderators on the board...not sure of the ful funcitonality yet, as you might have noticed!

paddy

PS EconSean - sorry for using your post as a test for this

 

[PaddyD]

I was still being told that a match couldn't be found.

This could be more to do with what you're typing in than the general method not being appropriate. care to post an example of the formulas you're trying to change, & exactly what you're typing in when you get the error messagfe.

paddy

 

[Tom Urtis]

Got it...thanks.

 

[PaddyD]

I was still being told that a match couldn't be found.

This could be more to do with what you're typing in than the general method not being appropriate. care to post an example of the formulas you're trying to change, & exactly what you're typing in when you get the error messagfe.

paddy

 

[EconSean]

Tom,

I have the same setup here (2002, XP). I can't figure out why it won't work for me.

In any case, your code (from another thread), with a very minor modification, is working beautifully for me as I write this note.

Thanks again.

Sean

 

[EconSean]

Paddy and Tom,

Now the method that was initially suggested (and which I had unsuccessfully attempted before ever postet my question here) is working; that is, I am just using the standard Edit - Replace method.

One caveat, I shut the file down and then reopened it, and it is now working. I can't for the life of me understand why it wasn't working initially.

In any case, I learned a little with the (Tom's) code that I ended up using.

Thanks.

Sean