find and replace within a hyperlink

[DebC]

I use Office 2003. I have an excel workbook with tabs from '1st' thru '31st'
for each day of the month. I set up an excel calendar with a hyperlink from
the '1st' day in my calendar to tab '1st' in my workbook. I then copied the
link to each day in the month. Now I need to 'find and replace' so that each
day in my calendar will link to the corresponding tab in my workbook (2nd,
3rd, etc). When I try to 'find and replace', I get a pop up that says
microsoft cannot find a match. Is it possible to use find and replace in
hyperlinks? 'preciate any help!

 

[Sheeloo]

Have you used a formula (HYPERLINK formula) to get the hyperlink?

In Find and Replace dialog box there is a drop-dwon called Look in... choose
the appropriate option there.

 

[DebC]

Thanks so much for replying. No I did not use a formula I right clicked and
selected 'edit hyperlink'. I actually have another formula within the cell.

 

[Sheeloo]

Did you try out my suggestion?

I inserted a few hyperlinks and then used Find and Replace. It worked for me.

 

[DebC]

I believe my problem may lie in the fact that I have both a formula and a
hyperlink within my cells. I deleted my formula and the find and replace
worked for the hyperlink. Wonder if it's possible to have my cake and eat it
too?
(Again, I truly appreciate your replying, and your help)

 

[Sheeloo]

You CAN find and replace withing a formula. Just choose LOOK IN as FORMULAS.

Can you send the file to me?

 

[DebC]

I have sent an email with the files attached. Thanks so much.

 

[Sheeloo]

Did not get the mail.

add @hotmail.com to my id to_sheeloo

Also what do you want to replace and with what? You must have mentioned this
in your mail.

 

[DebC]

resent...hopefully got it right this time

Did not get the mail.

add @hotmail.com to my id to_sheeloo

Also what do you want to replace and with what? You must have mentioned this
in your mail.