Hyperlinking all cells on sheet 1 to their corresponding cells on sheet 2

Hello,

I am a beginner to excel and have a workbook with 2 pages. The first page is an overview of the second page. The workbook is a matrix of the laws in all 50 states regarding various topics. I want each cell on the first sheet to hyperlink to its corresponding cell on the second sheet - in other words, I want A1 on first page to link to A1 on second page, A2 to A2 on second page, A3 to A3, B1 to B1, B2 to B2 and so on. I have attached a small sample sheet with the hyperlinks between the sheets included. Until now I have done it manually by doing control k for each cell and putting in the specific destination on the second sheet that I wanted it to hyperlink to, but I want it to be able to be done automatically since I have over 1000 cells. I am concerned with the hyperlinks between the two sheets, not the hyperlinks on the second sheet that link cells on the second sheet to other online locations.

Right click the sheet's tab, View Code, and paste. Select all the cells, cut, and paste back. Constant values without hyperlinks will be added. Then, any cell with no value that is added, will get the hyperlink.

Please Login or Register  to view this content.

I'm getting - error Run-time '5': Invalid procedure call or argument. The part of the code that is giving the error is in red.

Please Login or Register  to view this content.

I have word for mac if that makes a difference.

I isolated the row that was causing the issues. It's a single row that has numbers in it instead of letters. Maybe that is related to the issue at hand. For all the other rows, it works fine.

Thanks