I created a macro that is supposed to copy the contents of about 500 rows, and move them all up one row. One of the things that is contained in those rows are a bunch of hyperlinks to Microsoft Word documents. When I try to move the 500 rows up manually (just copying, and pasting one row higher), it works fine. The link remains entact.

However, when I use the macro I recorded, the link no longer works. You can no longer click on the link to go to the file. It looks like it is there (the text used to represent the link is there), but when you click on it, nothing is there. Here's my code. I'd appreciate any suggestions.

Please Login or Register  to view this content.