In searching the net I found this code that will transfer a worksheet full of text and hyperlinks
to a separate sheet, but I cannot seem to modify it to transfer that same sheet to a different
workbook that is opened.

I have tried a bunch of method, but always come up with some error, like "Subscript out of Range"
or "block not set". Can anyone help to modify this code so it will do what I need

thanks in advance

Please Login or Register  to view this content.