entirerow.delete

I am trying to remove entire rows that filter on certain criteria. I'm doing it by writing: Range(Cells(3, 1), Cells(LastRow, LastColumn)).SpecialCells(xlCellTypeVisible).EntireRow.Delete But I have grouped columns in my data so I get errors. My work around is to write...

Hello, I have been trying a lot of different methods to achieve the desired result however close but no cigar. The code below does what I need but I have an infinite loop which results in a run-time error. Sub DeleteBlankTesting() ' This code deletes empty rows if GRNSTATE is empty. Error to end...

Hello, I am struggling to figure out how to delete filtered table rows. In my file, I have reports directly connected to our report server and am trying to update my Macro to delete filtered rows. I have tried many different ways to do this and i keep coming up short. Below is an example of...

I have the following code that i resulting in an error due to it is too complex and not a contiguous set of data. I beleive it is due to there being too many rows for Excel to properly execute. I have scoured the forum to make something work in my favor, but have come up with incorrect...

Hi. I need to delete rows from a ListObject very fast, based on criteria applied on a date column. I get the 1004 Delete method of Range class failed error on the EntireRow.Delete line: Sub DeleteOldPhoneCalls(ByRef tblCalls As ListObject) Dim rngDelete As Range...

I have a spreadsheet where a "comment" section tends to have 100s of rows of trailing "#N/A"s. My initial thought was simply to filter on the comment column and delete those rows. But sometimes there is an #N/A in a row that has other useful info. To better explain: <tbody> ID Field2 Field3...

I found in an old thread here a macro deleting blank rows in an excel sheet, changing "pseudo blanks" into real blanks first. It was this little script: Sub RemoveEmptyRows() On Error Resume Next With Range("B300:B1000") .Value = .Value...

I have a procedure to sort and print a copy of the 'Summary' sheet of data - attendance records of a club. As part of the procedure the data is first sorted on column L using the Named range PupilTotal. This sorts the list in numerical order. The procedure is then to delete rows where the...

Hi, I want to delete row when my cells = 2 For i = 2 To a If Cells(i, 15) = "2" Then Cells(i, 15).EntireRow.Delete Next i But when the row it's deleted macro is skipped one row. How can I avoid the situation?

Hello, I am trying to code the following: I have supplier names in Column A, and I am searching by the name of the supplier by using the match command, which provides the Row value of the searched name. Then I would like to delete the supplier that has been found in the array. So I am using...

I try to delete all the rows in my table. I would be preferable not to delete the entire row, but only the in the table, but I guess it's not possible. When I use the code below it does what it should but ends with an error "Run-time error '1004': Application-defined or object-defined error"...

Hi all, In my on-going work project (that i thought was finished ><) I have code that basically does this: IF cell1 = cell2 THEN highlight entire row Blue. IF cell3 = cell4 THEN highlight entire row Red. This obviously cause problems when both are true as the as the you can't see both...

Hi Everyone, I have created a script that deletes a row based on a string found in the first column (referenced to another table with a list of strings to delete) What is weird is that the script works but is not deleting all rows that match the criteria. For example, if there are 10 rows...