How to copy cells with HYPERLINK function?
Hi, my problem is that I have thousends of cells with HYPERLINK function in
it, but I need to paste them as paste special so the hiperlink is still enabled but without leaving the function. |
How to copy cells with HYPERLINK function?
Here is a possible aproach that you may adapt to your sheet. Let's say we
have a single column of hyperlink formulas, column A. We will use a macro copy the material in column A to column B, but without formulas. 1. make sure column B is empty (it will receive the converted links) 2. enter the following macro: Sub cnvrt() Dim s As String For Each r In Selection s = r.Formula ss = Split(s, Chr(34)) ActiveSheet.Hyperlinks.Add anchor:=r.Offset(0, 1) _ , Address:=ss(1), TextToDisplay:=ss(3) Next End Sub 3. in the worksheet, hi-light the cells in col A that contain the hyperlink formulas 4. run the macro Non-formula hyperlinks will appear in column B. The stuff in column B is what you can copy/paste -- Gary''s Student - gsnu200732 "HYPERLINK Fuction and Paste Special?" wrote: Hi, my problem is that I have thousends of cells with HYPERLINK function in it, but I need to paste them as paste special so the hiperlink is still enabled but without leaving the function. |
All times are GMT +1. The time now is 06:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com