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.