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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"davemon" wrote in message
...
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