Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying hyperlinks with VBA in Excel 2003
I am using a macro to copy data from one sheet to a new sheet and a
new workbook. The original sheet has a column of working hyperlinks. I am copying with code like this: Workbooks("New workbook.xls").Sheets("Sheet1").Range("a" & i & ":dz" & i).Value = _ Range("a" & i & ":dz" & i).Value The hyperlinks do not work in the new sheets. How can I format the cells as hyperlinks or copy the original hyperlinks as hyperlinks? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
Excel 2003: Hyperlinks | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Hyperlinks in MS Excel 2003 | Excel Discussion (Misc queries) | |||
Copying HTML into Excel Losing Hyperlinks | Excel Discussion (Misc queries) |