Hi All,
Could someone please help me in getting a solution to this.
I have 2 sheets in excel file. If I click on a cell in sheet 1 , it should redirect me to same cell of other sheet. I have values in almost 200 cells. How do I do that without manually making it hyperlink and editing each one.
Thanks,
Shanck
The HL is fairly simple, but why would you want to link in the 1st place?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try below code. Please change sheet names, row and column number as per your requirements.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks