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
|