Forum Discussion
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...
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.