• 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


  • 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 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.