Tricky Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help making my stealthy macro even stealthier.

I want the macro to find a row where if column C is less then or equal to 90
and column A does not contain the words "Huzza" or "Rock On" it will copy the
contents of column B to column C. Now, i know that there will be come cases
where the info copied into column C from B will sometimes still be equal or
greater to 90 so i need to either make this little code run only once or put
a nice little if column B equals column C don't run. Or...something.

Is this possible? Do i just do a bunch of loops or ???
Your insight would be most valuable
 
iLastRow = C ell(Rows.Count,"C").End(xlUp).Row
For i = 1 To iLastRow
If Cells(i,"C").Value >= 90 Then
If Cells(i,"A").Value <> "Huzza" And Cells(i,"A").Value <> "Rock
On" Then
If Cell(i,"B").Value < 90 Then
Cells(i,"C").Value = Cells(i,"B").Value
End If
End If
End If
Next i

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top