I have a workbook that uses formulas to update hyperlinks (no VBA) to different areas in the workbook either on the same sheet or others in the workbook, the areas are described by volatile range names.
I was hoping there was some VBA way to get the workbook to autozoom to the selected range when the hyperlink is activated.
Any help appreciated.