delete empty rows

  1. D

    Removing blank/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...
  2. L

    Infinite Loop Correction

    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...
  3. S

    IDENIFY cell.value in row. Once found, CUT row, and paste into New Sheet

    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...
  4. B

    Loop (repeat) macro 100 times- Delete 1 Million rows

    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...
  5. K

    how delete empty rows?

    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...
  6. B

    error message on delete empty rows macro

    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...
  7. C

    How to transpose only populated cells?

    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...
  8. X

    Delete Row If Column A=""

    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.
  9. L

    VBA - Deleting empty rows

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top