Position the "hyperlinked cell" in the middle for easy view

[determinedtoexceed]

Dear Professionals,

I have a formula here that can target the wanted cell in the desired sheet, but it doesnt lock on the position for better view in the middle of window. Please help.

=HYPERLINK("#"&CELL("address",INDEX(Pivot!BL:BL,MATCH(MID(B358,1,6),Pivot!BL:BL,0))),MID(B358,1,6))

From above i am not sure how to combine the "address formula"? which will position the cell in the middle of my view. But i heard it is possible to do it with that formula.

Thank you for the hard work.

Best Wishes.

 

[jasonb75]

But i heard it is possible to do it with that formula.

Sorry to say this, but you heard wrong. It would only be possible with vba. See the answer provided here https://stackoverflow.com/questions/23318608/excel-center-screen-on-hyperlink-cell

 

[determinedtoexceed]

thank you Jason for the prompt reply.

it's a shame that it cant be done with a formula