Hi

What's references is the name you enter in the "Name" prompt. If you enter a
name that already exists or a name that excel can't assign (like, you can't
assign the name "C4" to cell D3 because C4 is in use for cell C4) then
errors appear. The code should trap this after some refinement, but that's
more that I will put into a newsgroup posting. Until you fix that, enter
obvious, silly, unique names every time.

The reason for using names in hyperlinks is because you probably want the
references /links to follow when you insert and delete rows or columns.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"ali" skrev i melding
...
Thanks very much for that, you've almost made me very very happy -
however at present the link appears to work, ie that cells are linked
(and turned blue) but when i come to click on the first cell i get the
message "Reference is not valid"

Any idea how to fix it - i've been waiting months for a solution so i'm
crossing all my fingers and toes!!

Once again, many thanks


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