View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DebC DebC is offline
external usenet poster
 
Posts: 39
Default find and replace within a hyperlink

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!