Thread: Hyperlink in merged excel worksheet not active

Hi Folks,
I have an Excel file with several worksheets (with the same format, but different data range). The excel worksheets contain columns of data that are hyperlinked to webpages. For easy transfer to the files, I merged the worksheets into a large excel sheet with a macro (kindly provided by Jeffrey brown on Mr Excel Forum). However, after the merge, the hyperlinks in the merged file is no longer active. Any idea to keep the hyperlinks in the merged file still active?
Thanks a lot in advance.


Peter Cheng