Links to Cells and Screen Position

[Indra7]

Hello,
On a monsterously huge spreedsheet that I'm working on,
I am using regular hyperlinks (not the Excel Hyperlink Function)
to link differant parts of differant worksheets.

My problem is this:
when the links are clicked, and you are taken to the target cell,
the target cell is usually in the bottom of the screen.

I'd like to have the target cell be on the top-left.

Any ideas on how to do this?

Thanks

 

[jeff]

Hi,

Add this: ActiveWindow.ScrollRow = xx

where xx is number of rows to scroll to position
properly.

jeff