View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Brown Gary Brown is offline
external usenet poster
 
Posts: 178
Default Active cell as a reference to open a worksheet

InsertHyperlinkPlace In This Document...
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"LaDdIe" wrote:

Hello,

Is there a way to use an active cell to jump to another worksheet,
I.E, Ive got a sheet with 53 cells with week commecing dates, ive also got
53 sheets named wk1 to wk53, I would a index sheet to use to jump to the
required wk? sheet.

Thanks for any help.