Follow Hyperlink to Page Center Data

[weaselmcguff]

I am trying to figure out how to center or put the Cell (J45) as the upper top left of the screen. (similar to hitting home) and going to A1. I don't want just part of the information to be shown which is J45. I want the J45-R77 Range to be all visible. Hope you understand what I am asking here.

Any suggestions?

Thanks

 

[Jerry Sullivan]

You could save a Custom View with J45 in the top left and J45-R77 visible.

Then you could restore that view either manually (through the Ribbon) or with a macro.