delete blanks

  1. B

    delete blank cells, shift populated cells right

    I have a very large spreadsheet with rows of data containing blank cells in the middle of a row. I need to delete the blank cells within a range and shift the populated cells to the right. I'm a vba beginner. Tried this in "this workbook": Sub Blanks()...
  2. F

    Deleting Blank Rows below data using a macro

    I'll try and explain this as best as possible. I am pulling external data into Excel in order to run some pivots off it. This data will start in cell B1. Column A contains a key, made up of the contents of this data. (e.g. =B2&F2&H2). This is then used to match against another tabs. I would...
  3. Prevost

    Passing arguments with worksheet_change to dynamically update ranges

    Hi There. I have found a sub that will dynamically update named ranges in worksheets. There are two things that I would like to know if possible. First, I would like to know if there is a way to disregard blank cells in that range (starting at A3 that goes to the last row). I am using that range...
    • Prevost
    • Thread
    • delete blanks passing arguments to subs worksheet change
    • Replies: 11
    • Forum: Excel Questions
  4. L

    VBA to delete blank cells and duplicates in different work sheet

    Hi, I tried the following code and it worked ok. But I want the results on a different worksheet, ie sheet2, in the same book. I also want to apply this only on the specific two columns F and G.(I want to leave the other columns as they are) regards, Listter Sub RemoveNoise() Dim...
  5. J

    Please speed up my vba code! Deleting rows based on blank cells

    Hey all, I found this code on the board and was able to edit it to do what I need it to do but it is realllllly slow. Any suggestions to speed things up? I have data in Columns A,B, & C. Most of Column C is blank. I want the rows where Column C is blank deleted, without deleting the entire...
  6. J

    Only delete rows when whole row is blank

    I have a real problem with a file I'm working on. It has invoice numbers in one column, followed by payment milestones. In the row underneath, there is an 'x' to mark if payment was made in a particular zone, e.g.: <TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0...
  7. O

    Delete Blank Rows in Column (PLZ)

    i have this file that is one column and multiple rows........ I need to remove all blank cells, I cannot use: "Remove Duplicates" on this one because i am have duplicates in my data. Thx in advance:rofl: Steve

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
Back
Top