Hyperlink to center screen in the selected cell

[Newbie73]

Hello everyone, I have a few hyperlink cells with the following formula:

=IFERROR(HYPERLINK("#Main!"&ADDRESS(MATCH(Summary!D22,Main!$C$1:$C$50001,0),2),"Test"),"")

It basically takes me to a different sheet with the same cell value as D22 on the current sheet.

It works perfectly, but is there a way to make it center on the selected cell? As it is now, it takes me to the correct cell but just at the border of the screen (which can be up or down) and it can be hard to spot the selected cell.

Thanks

 

[KOKOSEK]

Do you mean, scroll down/right/up/left itself destination sheet to make selected cell in center of screen, right?

 

[Newbie73]

Hello KOKOSEK, yes scroll down and up, right and left isn’t necessary as the columns are usualy within B and E, I have loads of those hyperlink (including in different sheets) but all follow the same formula. It’s just a shame it’s hard to see the highlighted cell, would be much easier to spot if it was in the middle of the screen