delete empty rows

I have a workbook that contains several different sheets of data. Two sheets, in particular, occasionally end up being unnecessarily long at the bottom/end of the sheet. There are many instances where the blank rows extend well beyond the data. This has increased my file size dramatically...

Hello, I have been trying a lot of different methods to achieve the desired result however close but no cigar. The code below does what I need but I have an infinite loop which results in a run-time error. Sub DeleteBlankTesting() ' This code deletes empty rows if GRNSTATE is empty. Error to end...

Howdy Monday Excel Experts, I have an idea of how I need to organize the code, but there are facets of knowledge here that I'm not acquainted with and was hoping someone could help me out... Trying to identify a value in a particular range, once that value is found, i need to CUT the entire...

Hi guys, I need to repeat the below code 100 times each time I click it. I have a spreadsheet with over 1,000,000 rows and throusands of columns. I am trying to delet the rows out. When I attempt to delet all the rows at once I get a message stating too much info is selected. If you know a...

Hello Excel Users!! Is there a way to delete empty rows in the data? a few months ago, I posted the same thread here, and, in reply, the VBA codes suggested to me were: Sub DeleteEmptyLines2() Dim r As Range Dim numCells As Long Application.ScreenUpdating = False...

I am trying to delete empty rows in the data sets that I import into excel. Sometimes the data sets have empty rows and sometimes they do not. The code below works in deleting empty rows if there are any, but if there are no empty rows to delete it comes up with a Run-time error 1004 saying "No...

Hi, I'm working in the fashion business :cool: I have a large database with data at style level (gender, product type, price...) and quantities size by size (s, m, l, xl) Typical data would be: women, sweater, $30.00, 0, 10, 15, 13, 6, 0, 0 for the following column headers: gender...

I need a macro that will delete an entire row if column A="" from a formula. It needs to start at A15 down. Thank you if anyone can assist me.

Hello everyone. This is probably a common question, but I am using a VBA macro to convert a .XLS to a .CSV and I need to delete all of the empty rows prior to conversion. I can find my first empty row with teh macro, but I don't know the syntax to delete from the current row to the end of the...