Go to cell address
 

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

Go to cell address
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tim" wrote in message
...
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

Go to cell address
 

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.