Add Hyperlinks Dynamically

  • I've been successful using the code below adding hyperlinks when I know where the information will be (i.e. a specific column). However, I'm looking to alter this to search by header names to the column to create the link. Reason being is many reports are created and depending on who or what columns of information is needed it may differ each time. Thanks for any feedback.

  • Re: Add Hyperlinks Dynamically

    I'm going to include the code that I "attempted" along with a data sample to see if that helps.

    I receive an error on the currentRng and anchorRng. Not sure what else to try.

Participate now!

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