Find value and offset a different value somewhere else.
Posted on 2014-12-02
In VBA how would I goto Sheet1, do a find task TP01.01 (which will be there and in column A). When it is found, goto column H and put in a "Passed". (or Failed). I have a variable called TestResult, if TestResult = True Then "Passed" and if TestResult = False Then "Failed". I believe an If Else would apply here but not sure how to frame it.