Search In a Macro/VBA

Giganews Newsgroups
Subject: Search In a Macro/VBA
Posted by:  cbanks
Date: Thu, 4 May 2006

It sounds simple but its really causing me problems.. Here is what I am
currently having to do..
If Range("J2") <> "Warn" Then
    Range("Q2").Select
    ActiveCell.FormulaR1C1 = "Warning"
    End If
    If Range("N2") = "PSSNAP" Then
    Range("Q2").Select
    ActiveCell.FormulaR1C1 = "Sales"
    End If
    If Range("L2") = "2669" Then
    Range("Q2").Select
    ActiveCell.FormulaR1C1 = "Warning"
    End If
Ok. This list goes on an on.. I basically have about 15 more strings like
this to add on.. Is there not away to have the macro search through the
columns and have it input my answers on the corresponding cell in column "Q"
if the data from column J/L matches what i need? I need help on this bad.
ASAP. Thanks a ton!

Replies