Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete cell value in ColE based on value is ColA
All,
I have a work sheet with data like this Col A___________Col B___________Col C___________Col D___________Col E 9812___________ Joe____________________________________________125 .00 *blank*__________ ____________________________________________125.00 *blank*__________ ____________________________________________125.00 Total __________ ____________________________________________ 375.00 What I want to do is delete value in Col E if the value in Col A of the same row IS NOT = Total Thanks Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete cell value in ColE based on value is ColA
Dim LastRow As Long Dim i As Long With ActiveSheet LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row For i = 1 To LastRow If .Cells(i, "A").Value < "Total" Then .Cells(i, "E").ClearContents Next i End With -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Steve" wrote in message ... All, I have a work sheet with data like this Col A___________Col B___________Col C___________Col D___________Col E 9812___________ Joe____________________________________________125 .00 *blank*__________ ____________________________________________125.00 *blank*__________ ____________________________________________125.00 Total __________ ____________________________________________ 375.00 What I want to do is delete value in Col E if the value in Col A of the same row IS NOT = Total Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete row based on cell value | Excel Discussion (Misc queries) | |||
delete row on based on cell value | Excel Discussion (Misc queries) | |||
Move data from sheet to sheet based on ColA | Excel Programming | |||
Delete columns based on cell value | Excel Programming | |||
delete row based on value of cell in row | Excel Programming |