Hyperlink to cell in separate workbook

  • Thread starter Thread starter rbeach
  • Start date Start date
R

rbeach

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
 
Put this macro in regardin sheet.whenever you will go through particular
sheet.it will select you the given range.

Private Sub Worksheet_Activate()
Range("B1:I19").Select
End Sub
 
If a macro is set in sheet, this will go to this range no matter where I
select a hyperlink to on this sheet. I will have many hyperlinks to different
locations in the separate workbook. each hyperlink will need to select a
separate range. The placeholder will need to be designated through the
hyperlink itself.
 
I have figured out what is needed to reference a range of cells in a
different workbook is:

=HYPERLINK("[\\192.168.1.1\My_Drive\My Files\KVA\CMS KVA KW READINGS
SHEET.XLSX]"&"$C$15:$J$27","PDU")

This will reference the computer with the external file by the IP address,
then directs to the correct folder and file name. The Cells are then
referenced and the last item is what displays within the cell. (In this case,
my cell displays PDU)

Thanks,
 
Back
Top