Re: Search In a Macro/VBA

Giganews Newsgroups
Subject: Re: Search In a Macro/VBA
Posted by:  Don Guillett (dguillet…@austin.rr.com)
Date: Thu, 4 May 2006

Not exactly sure what you want but this idea might help. NO selections.

if range("j2")<>"Warn" or range("N2")="PSSNAP" or  _
  range("l2")=2669 then range("q2")="Warning"

--
Don Guillett
SalesAid Software
dguillet…@austin.rr.com
"cbanks" <cban…@discussions.microsoft.com> wrote in message
news:DA244F7D-3F2B-43A8-95F6-539D1774E4…@microsoft.com...
> 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

None

In response to

Search In a Macro/VBA posted by cbanks on Thu, 4 May 2006