Thread: Tricky Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Tricky Macro


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)

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