Hi Nader, You can do this in one Go. Activate the second sheet. In the Cell A1, write "=" without double quotes and then go to Sheet 1 and select A1. Press enter. Press F5 and enter the last cell till where you want to hyperlink (say M500) Press Shift Enter. Press F2 and Ctrl+Enter. This will hyperlink all the cell from A1 to M500
Thanks and Regards, Upendra Singh +91-9910227325 -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of nader Sent: Friday, October 09, 2009 7:54 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ heyerlinking many cells Hello, I am trying to hyperlink many cells from one sheet to another one in the same excel file but I can not copy and paste the first hyperlinked cell to other cell because it always goes to the first cell. E.g. I want to hyperlink cell A1 in first sheet to cell A1 in second sheet and then A2 to A2, .. A500 to A500. Anybody knows how to do this? I really appreciate your help Nader --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
