delete a row

Hi I'm trying to create a macro whereby a whole row can be deleted if there are blank cells in column B I have the below which works perfect in terms of deleting the rows BUT keeps on running after completing, endlessly going. I have to ESC to stop it. What's wrong? Thanks in advance Sub...

<tbody> S.NO. NAME AGE LOCATION 1 JOHN abraham 34 WASHINGTON 2 <colgroup><col></colgroup><tbody> ANTONY RAJ </tbody> 30 NEW YORK </tbody> Hi everyone, I need to delete the row in column B if the name has small case letter. For example in JOHN abraham , abraham is in small case...

SO, I need to somehow edit the excel document so that when i convert the excel document to .csv, there will be no blank line at the end. This blank line that needs to be deleted before the file is converted to .csv.

I have been exhausting myself trying to appropriately create a macro that delete entire rows in my worksheet A2:LastRow of data based on certain criteria I have been working on creating a macro that deletes entire rows of all data if anywhere in the row there is a blank cell. Unfortunately, the...

Hi, I have a for loop (provided as an answer to a seperate question), this loop moves through every row with a value in column A. I now wish to reuse this code in a new way, to remove any rows that contain 110 or 111 within column A. I have drafted the below code but am not really sure...

Hi all! I have the following code which MickG has helped me with on this forum. Dim Rng As Range, Dn As Range, p As Variant, c As Long, Ac As IntegerWith Sheets("Candidates") Set Rng = .Range(.Range("I1"), .Range("I" & Rows.Count).End(xlUp)) End With ReDim ray(1 To Rng.Count, 1 To 5)...

I am trying to write a macro in excel 2010 that will go through all the cells in column L which is filled with numbers, if the cell number is between -1 and 1 I want to delete the entire row. Right now my macro is deleting everything except numbers that are between -1 and 1. When I switch the...

If the first character is "<" and last character is ">" then delete entire row Thanks

Good Afternoon folks, I have a workbook that runs several macros from data imported from my work system, all of which works fine. Apart from one report whereby I need to delete a varying number of lines from an individual workbook. The workbook in particular imports the data and sorts and...

Hi All, I have a userform(DelForm) with a combobox(cbDelAssociate). I am loading the combo box with a list of names from a table on a worksheet("2015"). With this code: For x = 3 To ActiveSheet.Cells(1, 1).SpecialCells(xlLastCell).Row If ActiveSheet.Cells(x, 1) <> "" Then...

I have a very large document with duplicate information. I have a column of Invoice numbers with matches, a column of material numbers with matches, a column of dollar amounts with matches. The variable is that I have a column with Days On that has a variation in it. I need to match the first...

Hello, I'm very new to the forum and am by no means an excel VBA pro. I have been asked to update our task tracking sheet for the office and could really use some help! My boss has asked me to create a macro that, when run (not automatically), will cut and move the entire row of a completed...

Hi, I have loop: For j = 10 to 500 x= ws.Range("C" & j).Value If x = 0 Then ws.Range("A" & j ).Select Selection.EntireRow.Delete End if next Example: j = 10 x = 0 Row is deleted, but code should once again check j=10, because when row is...

Hi, I have a database #1 of contact information consisting of e-mails, first name, last name, business name, etc. which contains many entries (rows) that need to be deleted. These entries would be deleted based on a secondary database #2 consisting of just e-mails. If there are duplicates...

Good afternoon! I am hoping I can get some guidance on creating a macro. I have a spreadsheet that consists of over 10k lines. I want to write a macro that will locate any cell in column b that contains "xxxx-825" and deletes the line. But when it deletes that line, I also want it to delete the...

My title sounds confusing. Essentially, I have a list of products that I pull weekly from a database and it contains all the products, active and discontinued. When I'm doing inventory ordering, I'd like to use a master "discontinued" list to filter out all the product that is no longer...

I'm using this code: Dim Firstrow As Long Dim Lastrow As Long Dim Lrow As Long Dim CalcMode As Long Dim ViewMode As Long With Application CalcMode = .Calculation .Calculation = xlCalculationManual .ScreenUpdating = False End With With ActiveSheet .Select ViewMode = ActiveWindow.View...

Hi I'm trying to write a code so that excel would go through each cell in a range and if the cell value is equal to "inputbox entered value" it will write ok and delete everything else. The problem is that if i'm assigning any other value in adjacent column or changing font types etc. then it...

Hi All, I have some data which I need to sort through and as part of my macro, I want to delete rows which contain certain text. So for example, in column G if the word "Late" appears in cell G50, I want to delete row 50. From other threads I have found the below code which works, but I now...

I am trying to delete rows that DON'T contain certain names, the code I currently have is: Function IsMember(v As Variant, vArray As Variant) As Boolean Dim vLoop As Variant For Each vLoop In vArray If v = vLoop Then IsMember = True Exit Function...