Run-time Error 1004, delete method of range class failed? (Code included)

[LIL2606]

Hi all,

I am trying to make this code work, and surprisingly.. it does.

Only, since I wrote the last section (from "Dim j as Long" onwards), I keep getting an error message, that "delete method of range class failed", but it does delete the rows that I wanted deleted, just pops up this error message. Anyone could help me fix this?
(I tried it with ActiveSheet.Listobjects, Sheet2.Listobjects, Sheet2.Rows, ActiveSheet.Rows with the Activesheet.Listobjects it does it just pops up the error message the others don't even do it and give the same error.)
Also it would be nice if I didn't have to write the whole "Wizz Air Hungary Kft." into the If just something like "Wizz*" but that doesn't work for some reason. Pls help!

Thanks

Please Login or Register  to view this content.

[CK76]

.Range is what's causing that error to appear.

Since you are deleting entire row, not just the table's data range. Just use ActiveSheet.Rows(j).Delete

If you just want to delete table row...

Please Login or Register  to view this content.

[LIL2606]

Error 438 object doesn't support this property or method and it doesn't do it now

[CK76]

Oh my bad on ListObject. You need Range argument for that one. Just not EntireRow.

[LIL2606]

It did it, but the 1004 error delete method of range class failed popped up again

[CK76]

Hmm, had no issue on my end. I'd recommend uploading sample workbook. Without it, bit hard to debug as I have no idea how your workbook is set up.

[LIL2606]

So

The SampleConverter is what I am working on, exact same code in it as posted here.

ConvertFrom is an excel file that represents the source file that the converter will have to work with. This source file is generated by another software we have
no control over, and is generated every month in the exact same format, so I thought I make a converter workbook that will format it for us as we need it.

Just open the convert from, CTRL+* CTRL+C and CTRL+V into the converter (second sheet A1)

Attached

Code runs, does what it needs to do, only it pops up the 1004 error code.

[CK76]

Oh, I see the issue now. You are trying to delete the header row.

Change "To 1..." to "To 2..."

Please Login or Register  to view this content.

[LIL2606]

AHH Magic! Very true! Thank you, it works just fine now!