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.

--
Rick


"Satyendra_Haldaur" wrote:

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

"rbeach" wrote:

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