delete a range of cells

  1. L

    Excel 2007 error: Method 'Delete' of object 'Range' failed

    Hi, I have written a sub with the purpose of finding rows based on a critieria, copying the rows to another worksheet and deleting the original row. The code: Sub MoveToIgangvaerende() ' ' Flytter opgaven til sheetet Igangværende projekter ' Dim i, j, Index As Integer Forfra: For i = -1 To...
  2. E

    Deleting blanks with corresponding cells

    I have a large amount data with dates in 2 columns (example below). I am trying to build a macro where it can detect the blank cells and then delete the blank with the corresponding date. I am able to delete the blanks but I can't get rid of the dates so my data will be skewed with missing data...
  3. S

    Delete Named Ranges and reset Excel's memory of previous ranges

    I'm trying to build a workbook that builds a query table based on a user's entry of a parameter and have this change when they enter a new parameter. I've built the macro so that it's structured like so 1) clear any existing data 2) get data from report 3) copy and transpose it to another...
  4. E

    Macro to delete row if column B is blank

    I am almost pulling out the white flag and surrendering to my evil enemy Macros. I am hoping that there is someone out there who can help me with How to I write a macro that will check rows on a worksheet to see if Column B is blank and if found it will delete the row regardless of what data...
  5. amitcohen

    Change code from delete entire row to delete a range of cells in a row

    Hi Guys I'm using the following code to delete empty rows But its only works on entire row. How to change the code so it will delete only first 10 cells that are empty. In other words, instead of deleting all row no 4 (for instance) It will only delete "A4:J4". and on.. and on.. Many thanks...

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