delete row

Hello, I have two sheets sheetA and sheetB with two names ranges rngA and rngB respectively. rngA in sheetA has one column and contains cell addresses (like, $F$6, $H$2, $G$3, ...) rngB in sheetB is say $F$3:$H$9 I need to delete cell addresses in rngA that are not in rngB. For example, $H$2...

I am having issue with a dynamic named range that is changing its reference if I delete a row from it using VBA. The Named range is: AllJobsData =OFFSET(Data!$A$7,0,0,COUNTA(Data!$C$7:$C$1048576),7) The VBA code below is designed to go through each line of AllJobsData, bottom up, and delete...

Hi! I have this code deleting all rows that do not contain the text "A#ABN" in column A. However, I also need to keep rows containing the value "A#UUW" also. Single delete works perfectly, but I struggle when adding more criteria. I´ve tried different versions of code two, but still noting:(...

Hi, I found a peace of code written bij Joe Was in: https://www.mrexcel.com/forum/excel-questions/9165-entire-row-delete.html I modified it to work on a command button. But it removes every other row :confused: Lets say row 11 till 18 are empty/< 1 then it removes 11, 13, 15, 17. I've...

Hi all I want to code the following: the macro has to delete the entire row if the value of the cell in column AR is "ABC", "DEF", "GHI" or "JKL". My code deletes only the rows containing ABC and GHI.. Could anybody see what's wrong in the code? Dim i As Range Dim wsTest As Worksheet Dim...

Good Morning, I have been searching for hours for the answer to this question. I have ZERO experience with VBA, but am trying to make an idea come to life. I have an excel sheet which pulls a bunch of data from an Access Query. I want the user of this spreadsheet, specifically tab/worksheet...

Hello, I have a spreadsheet where there are checkboxes for each row. I have a macro that deletes unwanted rows, but the checkboxes remain. How do I get them to be deleted when the row is deleted? Please save me! :) Mandy

This is a bit of a follow-up to my question here, where I inquired on using an array for in-string values to not delete a row. Thanks again to Peter, this saved me a ton of time. I'm now trying to work out the opposite, more or less: to delete a row if any value in an array is present. I'm sure...

Hello, I would like a macro that runs when the sheet is activated. I would like it to delete any row that contain white font, however the font will be white because of conditional formatting. Also, I can make that work otherwise if we could complicate it more and have it only look in Columns...

I have a text file with thousands of lines, one word per line. I'm trying to delete/remove lines that do not include one of multiple values, but not delete if there is a partial match of one of the values. This almost exactly what I'm after: <code style="margin: 0px; padding: 0px; border: 0px...

hi all, i need a vb script that progresses down thousands of rows in excel and deletes the row if there is nothing in the A column can anyone help!? Thanks

VBA for edit text and remove blank rowsI m finding out <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help;">VBA</acronym> for merging text with a space from below cells which has blank at...

Hi I am a newbie to Excel VBA Coding so take it easy on me i this is a stupid question. So, I will try to explain what I need as best I can: So, I have a spreadsheet (we'll call it S1) that has over 3000 rows of data. Each row corresponds to a customer that has various customer related columns...

Hello people, I have written a code that remove last added row, its very simple it counts from down to up my issue is I want the code not be able to delete row 1 and 2. I did wrote "A3" but its still possible. Dim lRow As Long Dim lCol As Long lRow = Cells.Find(What:="*", _...

Hi all, I have a macro giving me headaches.. Its goal is: 1. To copy 8 columns from 'Global List' to 'Front'. Global List sheet has some merged cells and Front sheet can't have them so as to be aligned with the rest of the info already there when I copy these columns. I use this code: Sub...

Hi I have a table containing conditional formatting applied to say $A$1:$A$324. Rows 1 to 324 cover all of the table rows. If I need to delete a table row (say row 317), the Applied to reference will say $A$1:$A$316,$A$318:$A$324 I thought if the data was in a table, the range would not be...

Hi all, I have a spreadsheet that has nearly 50,000 rows. In column J of this sheet, values are either "TRUE" or "FALSE." I am trying to delete every row in which the cell in column J is "FALSE." The following code works but it takes over three minutes to compile. Sub Delete_Rows() Dim ws As...

I need to erase the entire row based on 2 different cell values. I would like the Macro to all rows and columns on the sheet and delete the entire row if it finds a cell containing these 2 values: 1. WORK OF 2. RUN DATE Thank you - your help is greatly appreciated

Should be simple but I'm stuck on this: I want to clean up large files by deleting all rows where certain cells do (or dont) contain certain values. I'm fairly new to vba, so I did what I usually do and cobbled up my script from posts here and on other forums, and then resolved the runtime...

I have never used VBA so please be kind. I am trying to delete the entire row if a particular column (in this case C) is blank. I am not getting any errors, it just is not doing anything. Help! Here is what I have: Last = Cells(Rows.Count, "C").End(xlUp).Row For i = Last To 1 Step -1...