I copied a bunch of data from a website into an Excel worksheet but each line has one (or more) hyperlinks in it. I know I can right-click and remove them one at a time but I can't find a way to remove ALL the hyperlinks at once. Am I missing something?
"Laugh? I thought I'd die!"
Jimbo?
There is a quick way.
Bear with me. This removes all hyperlinks in thed workbook.
Please Login or Register to view this content.
Last edited by mehmetcik; 04-11-2016 at 06:45 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
If you highlight the entite range and then right-click on it, you can select "remove hyperlink"
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That doesn't work for me if I highlight more than one cell at a time. That is what I expected to happen (until it didn't work)
That worked! thank you!!
I tested it on some sample data and it seemed to work OK for me, but if teh code worked for you, thats greatOriginally Posted by jimboryan
Sorry to be a real dumb-***, but how would one use the code ?
ie: how would one enter it in Excel or Word ...... ?
tanguvellymush !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks