Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tricky Macro
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
link to combobox | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) |