Leandroarb
Board Regular
- Joined
- Oct 7, 2014
- Messages
- 157
Hi,
Please, a need delete cells equal "*".
I try use this code:
But... suceless
The datas are in columns
[TABLE="width: 83"]
<tbody>[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]03/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]04/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]15/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]02/11/2018[/TD]
[/TR]
[TR]
[TD]10/11/2018[/TD]
[/TR]
[TR]
[TD]11/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]17/11/2018[/TD]
[/TR]
[TR]
[TD]18/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]24/11/2018[/TD]
[/TR]
[TR]
[TD]25/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
</tbody>[/TABLE]
Every form of help is appreciated.
Thank you.
Please, a need delete cells equal "*".
I try use this code:
Code:
Sub DelTry()
On Error Resume Next
Do While ActiveCell <> ""
If ActiveCell.Value <> "*" Then
ActiveCell.Offset(1, 0).Select
Else
Selection.Delete Shift:=xlUp
End If
Loop
End Sub
But... suceless
The datas are in columns
[TABLE="width: 83"]
<tbody>[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]03/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]04/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]15/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]02/11/2018[/TD]
[/TR]
[TR]
[TD]10/11/2018[/TD]
[/TR]
[TR]
[TD]11/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]17/11/2018[/TD]
[/TR]
[TR]
[TD]18/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]24/11/2018[/TD]
[/TR]
[TR]
[TD]25/11/2018[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
</tbody>[/TABLE]
Every form of help is appreciated.
Thank you.