hello,

I am writing a macro in which I would like to search column A (which is a
long string) and see if it contains a word in there somewhere. If it does
then I would like column F to return the number in column C as a positive
number and if it does not then return the number in colum C as a negative
number.

thanks,
H