Thread: Go to cell address
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
  
Posts: 143
Default 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 With QuoteReply With Quote