clear cell

  1. J

    Remove cell contents based on date - VBA

    Hi everyone, Basically, I have a list of names and reasons for people being on a list. Plus the date their names were added to the list. What I'm wanting is for the line with their info to be removed after 7 days when we open the spreadsheet. Referring to the image, lets take row 2-4. Their...
    • JedZedOne
    • Thread
    • automatation automation vba clear cell excel macro vba
    • Replies: 3
    • Forum: Excel Questions
  2. G

    Clearing Contents if Col A equals value and also clearing D if not blank

    I have a situation where I'm wanting to clear the cell from Column A if it equals A, B, or C and also check that if D is not blank to clear that cell also for the entire sheet. Thank you in advance! COL A COL B COL C COL D c value value value clear A and D b value value clear A only...
  3. E

    Clear All Contents from Unprotected Cells Macro

    Hi all, I have a sheet that has many protected cells on it and then to the right of those protect cells are unprotected cells to put our daily usage totals in. After filling out the sheet we print it and then we need to clear the contents within the unprotected cells and start over for the next...
  4. A

    combining 3 if statements into one

    please help me.. i programmed cell k13 to remind me "billing due" if i have paid my bills or not using today() function..if we paid, we need to type "paid" into n13 and it should clear the text in k 13..if we haven't yet paid we need to type "not paid" and it should say "Billing due" these are...
  5. W

    Clear cells in a dynamic table depending on a certain value

    Hello I'm kind of new to Excel and I need help. I'm importing values to a table through a Query, but some of these values are incorrect and I would like them cleared. How do I tell Excel to automaticly clear all cells with the value "1901-01-01 01:01:01"? Thank you for helping.
  6. U

    Is there a way to update a cell without implementing a Worksheet_Change?

    I have four cells that are are dependent of each other using Data Validation. When I change the cell in column C it updates the pull down list in column D. This continues through F. The problem is that if I have all of this information filled in and I decide to start over by changing the cell...
  7. D

    Find text and clear all text from cell

    Hi Guys & Girls, I have a spreadsheet that contains various many cells with text contained in them. I want to be able to find all cells that contain "P001" and clear the entire cell, not just the "P001". For example I might have 3 cells (see below), I would want a macro to clear the 2 cells...

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