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