Go to cell address

[Tim]

Hi there,

I have 100 worksheets with different names.

At cell f10 of each worksheet... I want to go to cell m95 on each worksheet.

If I use hyperlink, I have to create each one seperately on each worksheet.

Is there anyway I can create one for all worksheets?
thanks

 

[Don Guillett]

Copy/paste this into the ThisWorkbook module. Now, on ANY sheet if you
select cell f12 you will goto m95. I suspect you may prefer to have this in
a right click or double click event instead.

Private Sub Workbook_SheetSelectionChange _
(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = "$F$12" Then Range("m95").Select
End Sub

 

[MyVeryOwnSelf]

I have 100 worksheets with different names.

At cell f10 of each worksheet... I want to go to cell m95 on each
worksheet.

If I use hyperlink, I have to create each one seperately on each
worksheet.

Is there anyway I can create one for all worksheets?

One way is to select all tabs at once and use this formula:
=HYPERLINK("#M95","Click")

Modify to suit.