| |||||||
| Domain Newbies New to domain names? Have your questions answered here. |
![]() |
| | LinkBack | Thread Tools |
| | #1 (permalink) |
| NamePros Regular | Microsoft Excel guru (please help) Hi, I'm trying to figure out how to put automatic hyperlinks in some web addresses - so they automatically click through to the site. e.g.: www.robin.com www.happy.net www.bigboy.org I've been trying to figure it out and i have 1000 sites to check out and really don't want to have to type them all in. I've tried inserting a hyperlink, but it doesn't come through as a live link. Any help would be greatly appreciated. Thanks
__________________ Buy Domain Names – 9i.com, 3J.com, CXC.com, FEJ.com, ZB.org, Foob.com, Wodo.com, Sixth.com – These are just a few of the great names on offer at namecake.com (Click below) Buy Domain Names Solar Garden Lights Virtual Reality Games |
| |
| | #3 (permalink) |
| Senior Member | i think what he wants is a way to visit sites from a url in an excel file by just clicking... one trick would be to take an empty column, and use the following: Code: =HYPERLINK(A1,A1) then just copy/paste that down (it should offer to fill in all of them if you just keep going down). it shoudl also automatically change A1 to A2, A3, A4, etc as you go down. then, you should be able to click those hyperlinks. does that help?
__________________ Hacksar.com - Your source for random computer tips and tricks! MySiteMemberships.com - Keep track of your site registration information! Like my post? Rep is appreciated! |
| |
| | #4 (permalink) |
| Domains my Dominion | I assume you have a column of URLs as non-clickable text correct ? To convert the text to hyperlinks you could run a macro like this, assuming your range is "a1:a40" PHP Code:
__________________ Buy now - MassDeveloper.com $500 |
| |
| | #6 (permalink) |
| NamePros Regular | Sorry for coming back late- been on holiday. The list i'm talking about has been merged - so no hyperlinks were created. Nasaboy - i tried what you suggested but didn't have any joy. Sdsinc- yes i have a column of url's as non clickable text - sadly i haven't got a clue how to apply the macro you have written.
__________________ Buy Domain Names – 9i.com, 3J.com, CXC.com, FEJ.com, ZB.org, Foob.com, Wodo.com, Sixth.com – These are just a few of the great names on offer at namecake.com (Click below) Buy Domain Names Solar Garden Lights Virtual Reality Games |
| |
| | #7 (permalink) | |
| Domains my Dominion | Quote:
Again go to menu Tools -> Macro -> Macros, select the macro you've just recorded and click Edit. You will see a new window with code like this: Code: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8/12/2008 by ... ' ' End Sub You may have to change the range (here a1:a40) to fit your needs. Return to Excel. Use menu Tools -> Macro -> Macros, and click Run to execute the code. This should convert the URLs to clickable links.
__________________ Buy now - MassDeveloper.com $500 | |
| |
| | #8 (permalink) |
| NamePros Regular | Thanks - i've tried it and still can't get it to work
__________________ Buy Domain Names – 9i.com, 3J.com, CXC.com, FEJ.com, ZB.org, Foob.com, Wodo.com, Sixth.com – These are just a few of the great names on offer at namecake.com (Click below) Buy Domain Names Solar Garden Lights Virtual Reality Games |
| |
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| |