clear cells

  1. A

    clear cell contents with vba

    I'm wondering how to clear contents in rows that have any cells that are not empty with vba from a certain row onwards. So from row 52 i want to clear all contents of any cells. everytime i do this my computer seems to crash, obviously haven't quite got the code right.
  2. B

    Clear range of cell content based on another cell value

    This is my first post. I have spent the better part of the day trying to adapt some of the code found here. What I want to accomplish is to clear a range of cells if the value of another cell does not equal a specific value. I have been able to get a macro to work but it is manual. I need the...
  3. R

    Clear contents of cell if before a certain date

    I want to clear the contents of cells on an entire sheet if the contents are a date before, let's say, 9/1/2008. Is there a macro for this? Thanks, RJ
  4. Joe Kickass

    How to delete blank rows?

    hi guys, I have a spreadsheet similar to the (poor) example below... Basically, i need to delete the rows that do not contain any data (i.e. rows 1, 6 & 9) A B C D E F 1 2 OK OK OK OK 3 OK OK 4 OK OK OK OK 5 OK 6 7 OK OK OK OK OK 8 OK OK OK OK 9 10 OK OK...
  5. R

    Deleting cells with a value

    I need help creating a macro that can clear all cell contents in columns L (L:L) and N (N:N) to the end of the Data and only cells with values greater than zero. Please help me if you can paste the code in the thread notes. Thanks so much in advance for your assistance. Have a nice day.

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