Creating hyperlink on cell entry change

  • Hi


    I'm trying to create a hyperlink to a folder whenever I add data to a cell in column C, however I'm getting a argument not optional in the Range.Cells... line. The code I'm using is



    Any ideas what is going wrong?

  • Re: Creating hyperlink on cell entry change


    Maybe, this.
    Me is the worksheet the code is running against.

    Code
    Me.Hyperlinks.Add


    You have to tell it was sheet, then the anchor is where the actual hyperlink will be.

    Bruce :cool:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!