Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
How to create table of cell names with the name's cell address | Excel Discussion (Misc queries) | |||
How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) |