Links to Cells and Screen Position

I

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
 
J

jeff

Hi,

Add this: ActiveWindow.ScrollRow = xx

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

jeff
 
Top