Using the Hyperlink function to go to TOP of another sheet 1

[shawnmandel]

Hi,

Is there a way, using the hyperlink function, to jump to the top of another sheet?

What I need is to be able to jump from the current sheet to the TOP of the destination sheet at the same column location in the destination sheet.

In other words, is there some type of parameter in the Hyperlink function that tells the cursor to go to the top?


I hope I am being clear enough?

Thanks very much,
Shawn

 

[Loomah]

Hi Shawn
The following will make the destination cell the top left cell in the destination sheet

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
ActiveWindow.ScrollRow = ActiveCell.Row
ActiveWindow.ScrollColumn = ActiveCell.Column
End Sub

Happy Friday


;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[shawnmandel]

Loomah,

Thanks for your feedback. However, I do not necessarily want the top LEFT cell. I need to go straight to the TOP cell directly from my current column location after a hyperlink jump to the second sheet.

Thanks,
Shawn

 

[shawnmandel]

Loomah,

I need a way for the cursor to automatically go to the top row as soon as the hyperlink is clicked on.

Thanks,
Shawn

 

[Loomah]

Shawn
Where is tthe hyperlink situated (sheet, cell) and what is it's target?

I haven't really got the opportunity to look at this in depth until Sunday at the earliest but will try to get back to you.

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[shawnmandel]

Loomah,

The hyperlink is located in a cell in sheet1 and the target is another cell in sheet2.

Thanks,
Shawn

 

[fumei]

I do not necessarily want the top LEFT cell. I need to go straight to the TOP cell directly from my current column location

AND

the target is another cell in sheet2

If I may point out:

"another" cell is not very specific; nor is "TOP" cell.

In fact, Loomah's code to bring it to the TOP left cell is exactly what you asked for. It IS the "TOP" cell...since you did not specify any other.

Gerry