ChuckFerrera
New Member
- Joined
- Jun 1, 2015
- Messages
- 2
Hello,
I am currently working on an automation project where I am receiving raw data of the parts in our inventory. I am then wanting to sort through the raw data to delete the unwanted rows of data, and then compare that "filtered" data to a set list of needed part numbers. The below loop is what I am currently using, but it is not deleting any rows of data.
Thanks in advance for any help you can provide!
I am currently working on an automation project where I am receiving raw data of the parts in our inventory. I am then wanting to sort through the raw data to delete the unwanted rows of data, and then compare that "filtered" data to a set list of needed part numbers. The below loop is what I am currently using, but it is not deleting any rows of data.
Code:
[COLOR=#ff8c00]'Loop Through & Count Number of Rows of PLCX[/COLOR]
[COLOR=#0000cd]Do Until IsEmpty(ActiveCell)[/COLOR]
[COLOR=#ff8c00]' Step down 1 row from present location.[/COLOR]
[COLOR=#0000cd]ActiveCell.Offset(1, 0).Select
If ActiveCell.Value Like "E ,2*" Or ActiveCell.Value <> "E, 2*" Or ActiveCell.Value <> "E,2*" Or ActiveCell.Value <> "E .2*" Or ActiveCell.Value <> "E. 2*" Or ActiveCell.Value <> "E.2*" Then
PLCXRowCount = PLCXRowCount + 1
Else
Rows(ActiveCell.Row).EntireRow.Delete
End If
Loop[/COLOR]
Thanks in advance for any help you can provide!