hyperlinks
Hi
I have created a hyperlink on a worksheet using the formula =HYPERLINK(BB1,BR1) this creates the hyperlink no problem what i want to do is copy the hyperlink from one worksheet to another worksheet when i try this i only manage to get the text value to paste can anyone please tell me how to copy and paste a hyperlink ? thanks in advance kevin |
Hi
should the copied Hyperlink still reference the old source cells? "Kevin" wrote: Hi I have created a hyperlink on a worksheet using the formula =HYPERLINK(BB1,BR1) this creates the hyperlink no problem what i want to do is copy the hyperlink from one worksheet to another worksheet when i try this i only manage to get the text value to paste can anyone please tell me how to copy and paste a hyperlink ? thanks in advance kevin |
Frank
thankyou for your reply The copied Hyperlink should not reference the old source cell kevin |
Hi
so you only want to copy the hyperlink information? -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ups.com... Frank thankyou for your reply The copied Hyperlink should not reference the old source cell kevin |
Frank
I want to copy the actual hyperlink from one workshet to another and have the hyperlink work on the second worksheet, targeting the hyperlink address not the original cell it was copied from. thanks kevin |
All times are GMT +1. The time now is 03:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com