Hello I'm familiar with other code but I'm trying to learn the lingo o
Excel/ VBA. I'm trying to write a condition statement that would allo
me to scan column B2 down and search for "SEL Book" if it finds thos
words I would like it to change the corresponding number in Column C t
a negative number. Logically put it would look like this.

If B2 through B etc. = "SEL Book" then C etc. = negative number...


Thanks for helping a Newbie

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