delete rows

I have a sheet with rows that extend to about Column AT. In some of the rows, all the cells are populated with "--". I want to delete these rows. Other rows have "--"s but not in every cell. I tried to remove all the "--"s then running this code: For t = 2 To...

Hi, I would like to set up a button where cells with "N/A" in specific columns will then delete the relevant row - the columns are Z, AA and AB. When I use the code below it does not seem to work. The code is the following: Sub Button3_Click() 'Declare variables Dim rngFound As Range...

Folks, How do I change this code so that it does not have to select the cells, but can activate them instead? 'Delete Filtered Rows Application.CutCopyMode = False Range("a2", Selection.SpecialCells(xlCellTypeLastCell)).Select Selection.SpecialCells(xlCellTypeVisible).Select...

Hi, I have been searching for a way to delete a row based on the value of a particular column. I keep finding "functional code" online, but they all result in automation errors for me. Basically, what I want to accomplish is this: When the "delete activity" button is clicked, excel will...

Morning all, I have created a code that allows me to remove rows based on a certain criteria. My limited VBA skills are now evident, as i need to extend this code across the entire workbook but have come a cropper! The code is as follows: Sub Delete_Rows() Dim rng As Range, cell As Range...

I have seen plenty of codes online but none of them seem to work with what I'm doing. I have 2 worksheets. I want the code to run so that when worksheet 2 from column B to D is equal to any value in worksheet 1 from column B to D then delete the entire row in worksheet 2 ONLY not both...

Hey there! I'm struggling with some code I found on another site (here:How to remove rows based on cell value in Excel?) The code works when I specify a specific value but I'd like to use cell.value like "*something*" For some reason this code doesn't seem to work... Sub Delete_Rows() Dim...

If I have a spreadsheet that sums a column of the rows above it, I obviously have to refer to the starting row/cell, say A3. I then refer to the ending row/cell, say A10. My problem is that my users will insert new rows above row 3, but my formula says start at A3. If there is a value to be...

I saw this post and I'm trying to determine how to replicate it for mutliple sheets. I have a sheet called "Discharge" which has clients who left the program in the past quarter. I want to remove anyone with an ID in the Discharge sheet in sheets Services (1) - (4). ID #'s are in column A for...

Hello all,I'm trying to write a VBA code that will allow me to reference column A, then find the all cells that have no data inputted. After this I want to delete said row(s). The issue that I am running into is because the data that I am using has been copied from another sheet referred to as...

I work with a spreadsheet every week to input values and subtotal them. These values change constantly and instead of going through and manually deleting each row in a 100+ row spreadsheet to be able to import into another program, I'm looking for an quicker way to keep my data in order but...

Hi I have a sheet that has letters and numbers in the "A" column but I want to keep only those that start with a number and delete all those that start with a letter here is the code that I adapted from another post : count = 0 For i = 7 To 151 Select Case Val(Left(Range("A" &...

Hello, I am trying to do a macro that would loop through desired sheets (ie. sheet 1, 2, 3... but not sheet 4) and run this code: Sub clearcells() '//Declare variables// Dim varDelItem As Variant Dim lngRowStart As Long, _ lngRowLast As Long, _ lngRowActive As Long...

Hello all, I have a list of data in Column A in Sheet 1, and in Sheet 2 I have 1000s of rows where that data may appear once, multiple times, or not at all. I would like to delete all rows NOT containing the data in Column A from Sheet 2. How can I do this? Let me know if you need more...

Ok, so I can't figure out how to do this at all. I basically have a spreadsheet with varrying number of rows. I want to check the value of a specific column (K) and if the value of that column is not in my named range I want it to delete the entire row. Currently I am using a lot of macros like...

Hi all, I recently found this macro on these forums for deleting rows where all of the cells are empty. Sub RemoveEmptyRows() On Error Resume Next With Range("B300:B1000") .Value = .Value .SpecialCells(xlCellTypeBlanks).EntireRow.Delete End With End Sub Unfortunately my...

So I have a user who has managed to max both rows and columns with empty cells in excel 2007. Even with everything else closed, I can only delete a few rows or a few columns at a time before I am forced to save. Generally if its maxed on either rows or columns, I can CTRL END and delete + save...

I need to insert and delete rows in a protected worksheet. When I set the protection, I indicate the user can access unlocked cells, insert and delete rows. After I save the worksheet and try to add rows, it will let me but it will not let me delete rows althought the access box to that task...

Hey there Mr. Excel board, This spreadsheet that I have been working on is up to about 1100 rows. Today, suddenly a ludicrous amount of rows appeared at the bottom of my spreadsheet- (All the way up to Row # 1,048,576!) As a result of this, my scroll bar on the right-hand side of my excel...

How is it possible to delete everything except Range("A1:D2")? I once saw something using Rows() in which it was specified to delete all rows from row 3. Is there any difference whether it's deleted or cleared? How can I be sure that it wont use memory?