offset macro based on multiple criteria
 

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

offset macro based on multiple criteria
 

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