offset macro based on multiple criteria

[davemon]

A little help needed from the gurus.........
I need the following to happen:
If in any row, the value in column 15 equals "trade" and the value in column
17 equals either "r" or "w", then offset(0,2).select.

Thanks in advance
Dave

 

[Don Guillett]

Look in the vba help index for FIND and combine with IF and OFFSET