Count the number of times this is in a column and put result in cell
Posted on 2014-07-23
How do I do the following in VBA. I can explain in English what I would like it to do.
Goto column O (letter not zero) of the active sheet, and count the number of times the letter “S” is there. Place the result in cell A6 even if it is zero.
Goto column Q and tell if there is a value of “WD” in that column? If so, place that value in cell A7, if does not exist, leave A7 blank.