delete a row

Hi all, I have vba code to update the workbook when there are changes in a table. My problem is that if I add a row to the table, it calls the code and updates the workbook, but if I delete a row, nothing hapens. My code is this on: Private Sub Worksheet_Change(ByVal Target As Range)...

Hello everyone! I have a problem that has me pulling my hair out. I have a spreadsheet with some buttons, when you click the buttons various reports are emailed off to various people. The email is made perfectly, and the file is attached ready to go, except there are two niggles. First the...

Hello Gurus, Good day! Could you possibly help me tweak the code below? Scenario is I have to delete the data that is below 500 including blanks and zeroes in Column E. Headers is located in Row A Sub DeleteRowIF() Dim zlr As Long zlr = ActiveSheet.UsedRange.rows.Count With Range("A2:AZ"...

Hi There , im really new to macro scripting. I have a word repeated in column 1, called "project:". once identified i need to count down and delete rows as per the following: count down 9 rows from the project row (and check if the column 1 word is "ID kV" if yes, delete that 10 rows...

Hi, I have this small section that I'm hoping to create a name-range from. In the sheet below, it is the bordered area with red text. I've been scratching my head trying to use Cells(Range("A1").End(xlDown).Row + 2, 2) - which gets me to the first cell in the table, in this case, B19, however...

i have no clue to doing this man, i expect the output is to be the right chart, but on the left chart is what i’ve done i want the cell to still remain the same number even the row is deleted and if i add new no. it still going +1 i need your help guys

Hi guys. I'm Excel noob and I've got a sorting task to do. Manually I will do it for ages. That's why I'm kindly asking for your help. I have a list of url links like this: and I would like to move every second row to a column next to the previous row and delete empy row. So it should look...

I know that the worksheet_change event is fired when a cell is deleted. Can I store the address of that cell that was just deleted to use it to then delete the same cell reference in other sheets? For example if I delete A3 on Sheet1, can I then select A3 on Sheet 2 and Sheet 3 and delete it on...

The code I am using runs only on the active sheet. It does not cycle through the workbook. Can anyone tell me how I can fix the problem? Sub Project2() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> "Portfolio" Then Rows(37).EntireRow.Delete End If...

Hi guys, I trying to start using VBA to automatize some task at work, I haved found a code that opened all files in a folder, and works pretty well, but now I need the following: Delete rows 1 to 3 and 6 to 7 mantain rows 4 and 5 Then look for an specific words "MONEDA NACIONAL", on the first...

Hello Guys, Hope all is well. I have a sheet with more than more or less 100k lines. I need to trim the data first by omitting rows with "0" or blank as Value in Row R (Sheet 1). I found below code but it's taking much time probably because the file is too large. Sub DeleteRow() 'DeleteRow ot...

Hey there, I have a workbook that contains two works sheets, let's say Sheet1 and Sheet2. What I want is that for the cells in Sheet2 Column A, if the cell value equals to the Sheet1 Cell D5, then delete the entire row. Can you help to let me know how to make it with VBA? Thanks!

Hi Everyone, I'm working on a project and am new to VBA. I've followed tons of tutorials online but I am stuck trying to delete a row in my table based on a selection made in a listbox within a user form. The purpose of the userform is to collect data on reallocating medication that was taken...

So i'll do my best to try and explain this. I have a spreadsheet with 2 tabs (DataExport; FilterCriteria) The DataExport tab is every computer i pulled from active directory (real long list) Column A is the PC name and Column B is the OU it resides in. The FilterCriteria tab Column A is a list...

Hi all, As part of a bigger macro, I'm adding code that will delete rows of data if the value in column O is 0 and I can't seem to get it to function correctly. Data in column O is a dummy variable that's been created based on data in other columns and is posted as a value, rather than formula...

Ok so I am still a little new to macros so be gentle and please help it will be greatly appreciated. I have a macro and I want to delete any row that has the following text in a cell ISN or MTS across 35 tabs. current macro is only deleting ISN and MTS in active sheet. Sub Delete_Rows_ISN3()...

Ran into an unexpected issue with conditional Table row delete. I have two tables with each checking the other for contents (with ISNUMBER & MATCH formula). I'm trying to delete all table rows from Table MASTER where ID value doesn't exist in Table QUERY - easy enough. After launching the...

Hello Everyone. I am using a macro to import data from other sheets in my workbook to a table. I am then using another code to delete rows with zero in column "E". The problem I am having is that it is deleting the entire row from the sheet, not just the table row. I have other information...

I’ve inherited a transactional database that’s causing meproblems as there’s no governance around changing things… Fix #1 I guess! In the meantime, I’m trying to get a solution. What I need to build is a macro that can pull downloadeddata into a new sheet (I’ve got this already) It then...

Hi All, I've gotten myself in a right mess, sulked like a child and deleted all my work! What I would like is the main body of a macro which I will hopefully adjust to what I need and I can call upon the sub within another macro. I want to be able to delete multiple rows if column A cells...