PDA

View Full Version : remove line



joeny0706
03-04-2019, 07:44 AM
Hi all


I am trying to make a macro that is probably simple to alotof you but being a pain for me. I have a list of macros to run but need onemore. I need to add one more to a xlsm file. Just need it to remove a row if thereis 0 in column E.

All the ones I have created are only deleting the celland not the row. Then just errors out.


I have a document that will convert data from handhelddevices for the delivers of the day. The data I am receiving has a line for quantity.

So, column E has the quantity. These devices record theitem even if zero are delivered. So when I upload this info to my accountingsoftware the invoices are showing items that were not delivered.

So I need each row that has a 0 in column E to be removed.If anyone want to help out it would be greatly appreciated.

Thanks all.

Paul_Hossler
03-04-2019, 08:41 AM
You're probably just missing the .EntireRow??





On Error Resume Next
With ActiveSheet.Columns("E:E")
.Replace What:="0", Replacement:=True, LookAt:=xlWhole
.SpecialCells(xlCellTypeConstants, xlLogical).EntireRow.Delete
End With
On Error GoTo 0

joeny0706
03-04-2019, 09:07 AM
Thanks Paul.

Without your help I would never completed my project.