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.

these are for the indivdual cells


Sub Macro14()
'
' Macro14 Macro
' Macro recorded 1/30/2008 by edingman
'
' Keyboard Shortcut: Ctrl+o
'
ActiveCell.Offset(0, 0).Range("A1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\Nss1\chevrones\30553-Crude-2\CADFILES\2CU.pdf", TextToDisplay:= _
"NO. 2 CRUDE"
End Sub


Sub Macro15()
'
' Macro15 Macro
' Macro recorded 1/30/2008 by edingman
'
' Keyboard Shortcut: Ctrl+e
'
ActiveCell.Offset(0, 0).Range("A1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\Nss1\chevrones\30553-Crude-2\CADFILES\2RS.pdf", TextToDisplay:= _
"#2 RESID STRIPPER"
End Sub


These are for the whole column


Sub HYPERLINK()

Range("H3:H300").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\Nss1\chevrones\30553-Crude-2\CADFILES\2CU.pdf",
TextToDisplay:= _
"NO 2 CRUDE"



End Sub





Sub HYPERLINK2()

Range("G3:G300").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\Nss1\chevrones\30553-Crude-2\CADFILES\2RS.pdf",
TextToDisplay:= _
"#2 RESID STRIPPER"



End Sub


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..