View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rbeach rbeach is offline
external usenet poster
 
Posts: 4
Default Hyperlink to cell in separate workbook

I need to hyperlink to worksheet "Mod2" cell "E4" in a seperate workbook
named "CMS KVA KW READINGS SHEET.XLXS". The below link works to open the
workbook but I need to know how to set it to go to the exact place on the
worksheet. If at all possible, I would like it to select the range from "E4"
- "I8".

\\192.168.1.1\my_drive\My Files\KVA\CMS KVA KW READINGS SHEET.XLSX

--
Rick