Hi All,
Need your help.
I want to copy only the hyperlink to a different cell. I have attached the sample sheet for your reference.
thanks in Advance
Regards,
Anto
Perhaps the Hyperlink() formula will assist you? Try this in B1:
=HYPERLINK(B2, A2)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
whenever i click on the hyperlink it gives me an error message. Is their a setting errror. The error message says "Unable to open http://www.google.co.in/.No program is registered to open this file".
I put that formula as shown into cell B1 on the sample sheet. (I did a cut/paste right from the forum).
Then I clicked on B1 and it took me to my web browser and opened http://www.google.co.in/
So, it works.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hi,
Refer the attachment file.
Sample workbook.xls
---
Sixthsense
---
Sixthsense
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks