Go to Tools -> Options - > View Tab
Select checkbox Formula in Window Options. Click OK
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: jmsprof <1su...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Wednesday, 11 February, 2009 7:50:13 AM
Subject: $$Excel-Macros$$ FIND / (RELACE) data in a hidden HYPERLINK
Hi,
I have a few hundred cells with some hyperlinks (in the cells there is
not the formula of the type: =HYPERLINK("...")..., where the hyperlink
text has been typed in directly in the cell, but rather, where the URL
has been hidden [select cell, then right click and select Hyperlink to
add the hyperlink).
Now if I use the basic MS Find & Replace, I cannot search the
hyperlinks.
Any suggestions as how to search the hyperlinks?
many thanks!
Connect with friends all over the world. Get Yahoo! India Messenger at
http://in.messenger.yahoo.com/?wm=n/
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
If you find any spam message in the group, please send an email to Ayush @
jainayus...@gmail.com
-~----------~----~----~----~------~----~------~--~---
