If I understand you correctly by clicking on a cell to supply that address,
you would actually be working with a HYPERLINK Worksheet Function
rather than code. You should be able select the cell on the other
location while building your formula.

If it is a HYPERLINK Worksheet Function you are working with, I have
some examples in

Worksheets in VBA Coding and in Worksheet Formulas
http://www.mvps.org/dmcritchie/excel....htm#hyperlink

With Ctrl+K or right-click then hyperlink
you would choose place in this document and type in the cell
address if in same sheet, but you can't select the cell to fill it
in automatically.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"index" wrote in message ...
Is there an easy way in excel to simply click on a cell in excel,
instruct excel that you want to create a hyperlink and then simply
select the cell to link to in the workbook?

Alternatively does anyone know how to create a macro that will instruct
the user to enter two cell references which will then be automatically
linked to each other?

If you imagine you are dealing with the most simple excel user you
won't be far wrong!!!! Thanks for any help!


---
Message posted from http://www.ExcelForum.com/