I have a list on numbers in a range and I have sheet names that include a prefix and the number. I am trying to set a hyperlink on each cell in the range. I've been trying to loop through the range and set it but it keeps setting the page addresses to the last value in the range. I've tried a bunch of different thing but I keep getting the same result. Here's the last thing I tried.
Any help would be greatly appreciated, and I'm open to suggestion for other methods to do this. BTW the range in the selection is dynamic.
Thanks! Tom
Bookmarks