Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying hyperlinks
Hi
When I use VBA in Excel 2003 to copy ActiveSheet.Rows(1).Value to another worksheet such as Worksheets(2).Rows.(1).Value, why the hyperlink function in ActiveSheet.Rows(1).Value does not work in the other worksheet? How do you make the hyperlink stay active in another worksheet? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying hyperlinks
Instead of just assigning the value, maybe you could copy|paste
Eric wrote: Hi When I use VBA in Excel 2003 to copy ActiveSheet.Rows(1).Value to another worksheet such as Worksheets(2).Rows.(1).Value, why the hyperlink function in ActiveSheet.Rows(1).Value does not work in the other worksheet? How do you make the hyperlink stay active in another worksheet? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying worksheets with hyperlinks to named cells | New Users to Excel | |||
Copying Hyperlinks | Excel Discussion (Misc queries) | |||
Problem with copying Hyperlinks | Excel Discussion (Misc queries) | |||
Copying HTML into Excel Losing Hyperlinks | Excel Discussion (Misc queries) | |||
hyperlinks and copying a worksheet | Excel Worksheet Functions |