clear cell contents vba

  1. E

    Script Crashes when run with anything but MsgBox test text.

    I'm new to excel VBA but I have now tested each part and they work correctly. What I'm trying to do is to simply delete the contents of a cell when the cells formula value is changed(no selection on entering key needed). The code is located under the sheet it runs in . Private Sub...
  2. M

    VBA Clear Contents of Cells Less than Today's Date

    Hi! I'm hoping you can help me with a VBA formula that clears the contents of dates in cells based on an end date that is less than today's date. My worksheet has a start date and an end date for multiple segments and these dates are associated with one another. The clear contents command needs...
  3. H

    Clear cell based on value of another

    I have a cell "intsel" that changes based on the value of the drop down "intseltext". "intseltext" is a list and depending on what is selected "intsel" value changes from 1-4. I would like to clear the value (not the formatting) from cell "digs" depending on the value of "intsel". Therefore...
  4. A

    Macro to clear certain range if a certain cell has a particular value

    Hi All, I am looking to run a macro that clears a range of cells if one particular cell has the word "Leftout" in it. I have the below code but not sure how to run it properly as when i prompt to run it asks for a macro name, obviously I am missing something here. So when Cell F20 has the word...
  5. K

    Clear Cells with Certain Criteria after specific date in VBA

    Hi, I am Fairly new to Excel VBA Coding, I would like to know what coding can I use if I want to clear a range of cells with certain criteria after a specific date. The cell's ranges are G5:J23 that I want to clear, I want to clear them if they contain "O/off" or "Weekly", but the cells...
  6. S

    Macro to copy contents to next blank column

    Dear Macro-gurus, I have data entry on Sheet1. The user fills in the answers as they go, and at the bottom of the questionnaire, there is a button marked "Submit". This button intends to trigger a macro, which copies all of the answers, pastes it to the next available column in Sheet2 and...
  7. C

    VBA to clear specific cells in a single row

    So simple I can't get it.:eeek: I need specific cells ("A1, A3, A5") to clear its contents after the (single) row is copied onto another sheet. Currently, I have it clearing the entire row (including a formula in A:3) when I only want these 3 cells to clear without removing the formula. Here...

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