Hi, everyone!
Whilst the following hyperlink codes work -
  With Worksheets(1).hyperlinks.add range("B2"), address:= "http://www.yahoo.com.", _ Screentip:= "Best Site", Texttodisplay:= "The Homepage"
 End With -

 I cannot get the address right when I want to add the hyperlink on
Range ("c2"), worksheet(2). When I click on this Range("c2"), it should direct me to the link at Sheet3!B2.
  Is there a shorter and faster way to create a hyperlink code that can connect to a specific location within the same Workbook that I want it to be without using Worksheet Functions?
   

Hi Chin,

Is this what you are looking for?

    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
        "Sheet1!H20", TextToDisplay:="goto Cell H20"

Change the subaddress to either a parameter that changes with the cell content.

Cheers

Matthew

Hi , Matthew !
    It should be what you have been given me, and that was what I read from books, but I cannot get it anchored to "C2".
Could you please show me an example on how to cahnge the subaddress that changes with the cell content?
   I am bit dumb here.