Using the 'Hyperlinks.Add' method for links within workbook

Hey all,

To make a sort of "error log" of erroneous rows, I am using the "Hyperlinks.Add" function in a Sub to dynamically link to a Range within the Workbook. The Sub executes successfully, however, upon clicking the hyperlink, a Reference not valid error comes up. I'm unsure on how linking within a workbook works, and could use some advice/pointers. Note that I also attempted to list the address as Address:="" to no avail. Here is the code:

Please Login or Register  to view this content.

Thanks in Advance