I have a formula in a column that uses the text from a different
column to provide a value - however, I am hoping that if I use vb to
make the formula, I can enter text into the column the formula
references and therefore only need one column. Is this true? If so,
how would I use this formula in column B in vb to eliminate the need
for column D?

=+HYPERLINK("https://na7.salesforce.com/search/SearchResults?
searchType=1&sen=0&setLast=1&sbstr=" & D4,D4)

Thanks in advance for your help,

magmike