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