View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default jump to active cell in other sheet .

Not possible using go to (F5)

--
Regards,

Peo Sjoblom

Portland, Oregon




"mongkolkorn" wrote in message
...
Thank for you answer.
but I want to use press key F5 and jump to other sheet ...,active cell in
other sheet .....

--
mai


"Pete" เขียน:

You could put this formula in cell A1 of Sheet 1:

=HYPERLINK(#'Sheet 10'!A10,"jump")

Note that there is an apostrophe after the # and before the !. This
will put the word "jump" in cell A1 and when you click this it will
take you to cell A10 of Sheet 10.

Hope this helps.

Pete