Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Column T contains then
Dim Defragglerow As Long
Dim RockroadRow As Long Defragglerow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row For RockroadRow = 1 To Defragglerow With Cells(RockroadRow, "T") If .Text Like "TACO*" And.Offset(, 52).Text Like "*Blank*" Then Cells(RockroadRow, "F") = "SOFT TACO" End If End With Next RockroadRow End Sub If any row in Column T contains TACO anywhere and that same row in Column BA is blank I want to change the contents in Column F to €śSOFT TACO€ť. I entered the code I have so far above. Can you help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Column T contains then
try this.
If UCase(.Text) Like "TACO*" And .Offset(, 52).Text = "" Then -- Don Guillett Microsoft MVP Excel SalesAid Software "JHopper" wrote in message ... Dim Defragglerow As Long Dim RockroadRow As Long Defragglerow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row For RockroadRow = 1 To Defragglerow With Cells(RockroadRow, "T") If .Text Like "TACO*" And.Offset(, 52).Text Like "*Blank*" Then Cells(RockroadRow, "F") = "SOFT TACO" End If End With Next RockroadRow End Sub If any row in Column T contains TACO anywhere and that same row in Column BA is blank I want to change the contents in Column F to €śSOFT TACO€ť. I entered the code I have so far above. Can you help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Search for a column based on the column header and then past data from it to another column in another workbook | Excel Programming | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C | Excel Programming |