Deleting non-hyperlinked cells should not affect hyperlinks cells.
Hard to tell what is going on. Have you tried using the Hyperlink function instead?.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - Free trial of "List Files" - create hyperlinks to files on your drive)



"Ed Dingman"
wrote in message
Morning all,
I have been working on this for a few days and I am stumped..

I have a worksheet and I am trying (somewhat unsucessfully thus far) to have
cells hyperlink in the same column that have 2 different values I do have
the macro that will hyperlink the individual cells as well as hyperlink the
whole column but there are rows that seperate the circuits so I do not want
ALL the cells hyperlinked..

I have also tried to create a new column and have them alternate values but
it seems when I delete information from the cells that it does not pertain
the hyperlink (though not the text) is removed from the whole column (also
not what I want)

this is what I have so far.
-snip-
I an Brand new to macros and VBE in Excel and need help
what I am looking for is this: Is there a way to automaticaly hyperlink
cells as soon as text is added? Is there a way to link to 2 different files
within the same column? if not is there a way to keep the hyperlink behind
the text when I delete the non pertnant text from the other column?

Thank you for any help you can offer in this matter..