Centering on a Hyperlinked cell

http://www.excelforum.com/showthread.php?t=634418
is a post i did some time ago it has code for centering when jumping via hyperlink
it should be able to be automted on click or similar

Originally Posted by martindwilson

http://www.excelforum.com/showthread.php?t=634418
is a post i did some time ago it has code for centering when jumping via hyperlink
it should be able to be automted on click or similar

Thanks for the code, do you have any suggestions for applying this code to a specific hyperlinked cell. I hate to complicate things (plus this may sound wierd) but my original example was only a freaction of my hyperlink formulas. I actually have 12 different cells that each search a different sheet in my workbook for a match with C2 on sheet 1, so H4 searches in sheet 2, I4 searches sheet 3, J4 searches sheet 4 and so on.

Is there a way to apply your VB code to all 12 cells?

Originally Posted by NBVC

A sample I did myself using your formula worked as expected highlighting the first occurance of a match to C2 in Sheet2!C:C.

It would be better if you supplied your own sample spreadsheet and tell us when it doesn't work as expected.

Its not that the function doesn't work, it will find a match without any problems. My issue is that i would like the screen to center on the matched cell. Depending on a number of factors, once I hyperlink the matched cell may be at the very top or bottom of the screen. Sometimes it is pretty close to centered, but I want it to be consistant.