| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
Hi,
I want to copy hyperlink property of one cell to another cell using excel programming. Thanks in advance. -- (:P) ee (  ) i |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
try this code.
Sub test() a = Range("D16") ActiveSheet.Hyperlinks.Add Range("D1"), a End Sub "PeeDi" wrote: > Hi, > > I want to copy hyperlink property of one cell to another cell using excel > programming. > > Thanks in advance. > -- > (:P) ee ( ) i |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Thanks Joel....
however the scenario is this.... Range 'a' has value "Click" and is linked to "www.testpage.com" i want to copy it to another Range say 'b'=(different in different scenario) which is in worksheet 'wkSht' (a variable) and its rows and columns are in variables 'r, 'c' -- (:P) ee ( ) i"Joel" wrote: > try this code. > > > Sub test() > > a = Range("D16") > ActiveSheet.Hyperlinks.Add Range("D1"), a > > > End Sub > > > "PeeDi" wrote: > > > Hi, > > > > I want to copy hyperlink property of one cell to another cell using excel > > programming. > > > > Thanks in advance. > > -- > > (:P) ee ( ) i |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Is wksht the name of the worksheett or a worksheet object?
Sub test() a = Range("D16") worksheets(wkSht).Hyperlinks.Add cells(r,c), a End Sub or (if worksheet is an object) Sub test() a = Range("D16") wkSht.Hyperlinks.Add cells(r,c), a End Sub "PeeDi" wrote: > Thanks Joel.... > > however the scenario is this.... > > Range 'a' has value "Click" and is linked to "www.testpage.com" > > i want to copy it to another Range say 'b'=(different in different scenario) > which is in worksheet 'wkSht' (a variable) and its rows and columns are in > variables 'r, 'c' > > > -- > (:P) ee ( ) i> > > "Joel" wrote: > > > try this code. > > > > > > Sub test() > > > > a = Range("D16") > > ActiveSheet.Hyperlinks.Add Range("D1"), a > > > > > > End Sub > > > > > > "PeeDi" wrote: > > > > > Hi, > > > > > > I want to copy hyperlink property of one cell to another cell using excel > > > programming. > > > > > > Thanks in advance. > > > -- > > > (:P) ee ( ) i |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Thaks a lot Joel....wksht is worksheet object....
-- (:P) ee ( ) i"Joel" wrote: > Is wksht the name of the worksheett or a worksheet object? > > Sub test() > > a = Range("D16") > worksheets(wkSht).Hyperlinks.Add cells(r,c), a > > End Sub > > or (if worksheet is an object) > > Sub test() > > a = Range("D16") > wkSht.Hyperlinks.Add cells(r,c), a > > End Sub > > "PeeDi" wrote: > > > Thanks Joel.... > > > > however the scenario is this.... > > > > Range 'a' has value "Click" and is linked to "www.testpage.com" > > > > i want to copy it to another Range say 'b'=(different in different scenario) > > which is in worksheet 'wkSht' (a variable) and its rows and columns are in > > variables 'r, 'c' > > > > > > -- > > (:P) ee ( ) i> > > > > > "Joel" wrote: > > > > > try this code. > > > > > > > > > Sub test() > > > > > > a = Range("D16") > > > ActiveSheet.Hyperlinks.Add Range("D1"), a > > > > > > > > > End Sub > > > > > > > > > "PeeDi" wrote: > > > > > > > Hi, > > > > > > > > I want to copy hyperlink property of one cell to another cell using excel > > > > programming. > > > > > > > > Thanks in advance. > > > > -- > > > > (:P) ee ( ) i |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| RE: copy a hyperlink to another cell | Mike H | Microsoft Excel Programming | 0 | 20th Mar 2010 03:52 PM |
| Copy only hyperlink to a new cell | Mike_Gormley | Microsoft Excel Misc | 0 | 15th Oct 2009 05:17 PM |
| RE: Copy only hyperlink to a new cell | Gary''s Student | Microsoft Excel Misc | 0 | 15th Oct 2009 04:32 PM |
| Copy hyperlink from one cell to/as hyperlink in another cell | YogS | Microsoft Excel Worksheet Functions | 6 | 12th Jan 2006 11:57 PM |
| vba programming copy/ paste cell values help. | yaoming | Microsoft Excel Programming | 3 | 13th Feb 2004 08:03 PM |
