
Signature
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.
Did you use Insert|hyperlink type hyperlinks?
If yes,...
If you've sorted the data, you may find that the hyperlinks assigned to the cell
aren't what you need for the data in that cell.
I like to use the =hyperlink() function in an adjacent cell. Then I can include
that column and do all the sorts I want and not lose the association.
So depending on what you have in the cell (not the hyperlink itself):
=hyperlink("http://" & a1, "Click me")
may work ok for you.
If you have lots of the insert|Hyperlinks type hyperlinks that you want to
delete, youc can do this:
Select the range to clean up (all the cells on that worksheet???)
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete
Then go back to excel and see if it worked ok.
> This question has been asked in previous posts, but not specifically
> responded to
[quoted text clipped - 10 lines]
> I say : I don''''''''t even know, I don''''''''t
> know nothing.

Signature
Dave Peterson
Learning Excel - 30 May 2008 15:12 GMT
Thanks for you time Dave.
Is not working either way for me, and I think I did not explained right,
I'll try my best :
I use just one worksheet and is called websites.
Everytime I go to a website I'm interested, instead of saving it in MY
Favorites,
I copy the toolbar address and paste it in my worksheet, probably thats a
link, not a hyperlink, sorry.
Then I right click and do edit hyperlink and give it a name EX: "discussion
group" for this one we are on.
Then I select A1 to A300 and SORT alphabetically.
Here comes my invention :
I did data valitation for those links, or hyperlinks who knows now, and
when I drop down I was expecting to get directly link to the website I
selected, but of course is not that easy. Now your turn... uff...tired.
Thanks.

Signature
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.
> Did you use Insert|hyperlink type hyperlinks?
>
[quoted text clipped - 36 lines]
> > I say : I don''''''''t even know, I don''''''''t
> > know nothing.