stixmcvix
03-29-2012, 07:05 AM
Hi there,
I used the fantastic VBA code provided on here vbaexpress.com/kb/getarticle.php?kb_id=195 for generating cell references to a text string. I have multiple worksheets, and the macro returns a long list of correct cell references with the search term in.
However..... clicking on the hyperlinks generates the error message: "Reference is not valid". If I hover over the hyperlink, the link looks fine to me, so for example for the cell text which reads: "APAC China Q4!A1943" the hyperlink is "file:///C:\VICTORIA\Market Insights Data\2011 ALL QUESTIONS GLOBALLY.xlsm - APAC China Q4!A1943" - but like I said, clicking it up kicks up the error message.
Does anyone know where I might going wrong.
For info, I have macro security set to enable macros and I am in Excel 2010.
I used the fantastic VBA code provided on here vbaexpress.com/kb/getarticle.php?kb_id=195 for generating cell references to a text string. I have multiple worksheets, and the macro returns a long list of correct cell references with the search term in.
However..... clicking on the hyperlinks generates the error message: "Reference is not valid". If I hover over the hyperlink, the link looks fine to me, so for example for the cell text which reads: "APAC China Q4!A1943" the hyperlink is "file:///C:\VICTORIA\Market Insights Data\2011 ALL QUESTIONS GLOBALLY.xlsm - APAC China Q4!A1943" - but like I said, clicking it up kicks up the error message.
Does anyone know where I might going wrong.
For info, I have macro security set to enable macros and I am in Excel 2010.