I needed to select all cells on Sheet1 between C5 and BE44, so I created a 'C5:BE44' hyperlink.
But when I added a column of data to D4, the hyperlink became invalid unless altered to read 'C5:BE45'.
BE44 is actually empty. Could I put a name in that cell, like WOW, and have the hyperlink go there regardless of its location in the page?
I tried 'C5:WOW' but it says 'invalid reference'.
Thanks for reading