delete a row

hi guys I am using the code below to delete rows, the problem is that this is very slow. Is there a way i can perform this a bit faster? Thank you Sub DeleteRows() Dim c As Range Dim SrchRng Set SrchRng = ActiveSheet.Range("i10", ActiveSheet.Range("i1654").End(xlUp))...

I am including the code below: The code should delete a sheet and then remove the index entry from the Main Page called "Working Lead" When ever I delete a sheet Excel shuts down with an Unexpected error. Excel 2010 & Win7. Look For The Green Comment Line below - This is where the crash happens...

For some reason I can't get this code to work. I have multiple sheets within this workbook and multiple sections where "#REF!" is found with data in between - for this reason I was told to start from the bottom up on each worksheet. I would like the code to look to column A and find any cell...

Does anyone know how to sort after a loop command using the same macro? Can you also in a loop command add a sheet reference in a cell that references the sheet you just created? I am trying to create a workbook that has a worksheet for everyday and then a master sheet at the end. I have the...

Hi all, I have a sheet using conditional formatting to highlight cells that I want to keep. I'd like to have a macro that will delete all rows without yellow cells. I think autofilter would be the best thing to use, but after searching the forums and trying a number of different approaches, I...

So I have a spreadsheet driven by some data-entry cells and macros, whereby information from the input forms is added to a table... As part of this process, I want to create a standard button (form control) that can later be clicked to delete the associated row (i.e. the table entry)... Here's...

I have found this code from another thread on this forum for deleting the row that contains a cell (in column B) that begins with a specific letter. I would like to perform the same task for numbers. Simply replacing the C* with 2* has not worked. Any help is greatly appreciated. Sub...

Every day I get a large worksheet with thousands of rows (each day it's a different number of rows), only 50-60 of which I'm actually concerned about. I've been using interactive filtering to limit my view to just the relevant rows, but the row numbers don't change, so that suggests to me that...

I currently have the code below; Private Sub CommandButton1_Click() Dim Response As VbMsgBoxResult Response = MsgBox("Are you sure you want to delete this waiting list?", vbExclamation + vbYesNo) If Response = vbNo Then Exit Sub Sheets("Home").Select Sheets(ComboBox1.Value).Delete Unload Me...

Hello, I am looking for help with a macro, or a entirely new macro. Here is my situation: I have a list of data (Sheet2) I have a list of terms in Sheet 1 that i need to delete the entire row from Sheet 2. The macro provided works but it seems to only delete the first time each of the terms...

Hello! I was wondering if there is a formula or command to find and delet specific rows. I want to remove people from an excel email list. On Sheet 1, I have 500 rows with columns for first name, last name, and email. On Sheet 2, I have 30 rows with columns for first name, last name, and email...

I have found codes for deleting a row if a column contains a set of letters, but I can't seem to find anything that would delete the row if the column doesn't contain certain text. Sample data: *A****B****C****D****E*******F 4/23*james**1hr**r32**RTS_21***9 4/23**Leo***2hr**lpl***RPLN*****23...

Wondering if there's a macro that can do this when i press a button. In spreadsheet "Complete Backlog" Autofilter on Show rows where WIP Status (Column K) equals "Closed" Cut rows Paste into next available row of "Closed Jobs" spreadsheet. No overwrites. Or you could switch step 5 and 6 so...

Hi, I need to review a 400,000 row spreadsheet and remove all records where 5 columns are populated with data so I am only eft with records that are missing information. I haven't got the slightest clue how to go about this using VB. Any and all help very much appreciated

I have a workbook with 10 sheets. When I delete one row (any row - each time i choose which one to delete) in sheet A I would like the same row to be automatically deleted from sheet B. How can this be done? TIA

Hi, I currently have a program written that pulls data onto 3 separate worksheets. I'm looking for code I can put into a new module that will delete rows with with no data in each worksheet. I have the following, however when I run my program as a whole I get an error stating "nocells" Sub...

Hi everyone, I have VBA code that attempts to delete an entire row from my worksheet: Cells(3,1).Select Selection.EntireRow.Delete This works fine on small data sets, but on larger data sets it gives me the error message, "Excel cannot complete this task with available resources". This...

hey, i'm creating a database on excel and i've come across a problem, on sheet "database" i have data starting from b2-e2, headed, reference number, product name, description , date respectivley there is data underneath and keeps adding. what i need is a macro code to do the following, i want...

Thanks in advance! I have a excel 2010 spreadsheet that has a column "H". In column "H" many of the cells have the folowing data: "Department Open PM Count :" and in this same column "H" some of the cells directly above the cell data: "Department Open PM Count :" has a cell value of: "Call #"...

Help! I am trying to find a VBA solution to allow users to delete one or more rows at the bottom of an excel table (preferrably one row at a time); i.e. users may have inadvertently added new rows that they now want to delete before finalizing the report. The worksheet is protected. Below is...