Forum Discussion
Wrake
Dec 30, 2020Copper Contributor
Drag and Drop jumbles Hyperlinks
I have a workbook with many hyperlinks per page. Some are to other cells in the same page or workbook, some to other files in subdirectories of directory containing workbook and some are URLs. If I d...
Wrake
Jan 01, 2021Copper Contributor
I forgot to explain the attachments. Hypertest is the "Before" sheet. This is extracted from a multisheet workbook. It has personal information, but on this sheet everyone has been dead for at least a century. Hypertest2 is the "After" sheet. Cells G459-Q482 have been Ctrl/Dragged and Dropped 2 columns to the right. In this example, all the Hyperlinks that have been dragged have been cleared.