• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vba code to insert hyperlink based on named range

Hi,

I want to hyperlink Sheet1!A2 cell to Sheet2!B2

I want to automate hyperlink through Vba code.

Please find attached the sample file.
 

Attachments

  • bulk hyperlink using vba.xlsx
    8.8 KB · Views: 5
Hi thanks for the reply.

This is not the desired result.

I wanted to create a hyperlink between Sheet1!A2 and Sheet2!B2. if i click on Sheet1!A2 it should move to Sheet2!B2 and there should be corresponding back button adjacent to Sheet2!B2 that will move back to Sheet1!A2.

I wanted to replicate the same hyperlink step to Sheet1!A3 and Sheet2!B3, Sheet1!A4 and Sheet2!B4 and so on.

Hence require VBA code.

Please suggest.
 
Back
Top