Hi Lawlera,
Don't know what you mean by automatically name cells to their
own value. Perhaps you mean get their value from the cell
being linked to. But you can't have two cells reference each
other, as that would be a circular reference. But you could
have one of them refer to the cell next to the other.

That way you can use your IE browser's Forward and Back
button or the toolbar web components arrow icons.

Worksheet Formulas -- no programming required, You can
generate them from your macro.

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

No address cell is within double quotes so the formulas will adjust if you
insert/delete rows or want to use the fill-handle.

Worksheets in VBA Coding and in Worksheet Formulas
http://www.mvps.org/dmcritchie/excel....htm#hyperlink
--
---
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

"Lawlera" wrote in message ...
Hi,

I am after find out if it it possible to automatically congfigure hyperlink text in cells to point towards cells of the same name
within the same sheet, also if it is possible to automatically name cells to their own value?

TIA