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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top