Hi guys,
The script below creates hyperlinks to cell A1 on every sheet in a workbook. Everything is running fine but I have a problem.
Instead of sheet name, I need to output the name of the cell it's referencing. For example, Sheet1 has in A1 "words". So, instead of displaying "sheet1" add "words" as hyperlink title![]()
Please Login or Register to view this content.
Instead of "back to index", I need the hyperlink to display the original context in that cell.![]()
Please Login or Register to view this content.
Right now, If A1 from Sheet1 contains "words" and I run the script then it will be transformed in back to index. As before, instead of "back to index" disaplay "words"
Below is the full script (got it from ozgrid.com). I'm sorry if I couldn't explain any better. If requested I'll add a sample. thanks guys.
![]()
Please Login or Register to view this content.
Bookmarks