cell delete

  1. M

    Need VBA that deletes content of cell based on adjacent cell's date being older than 21 days

    Let's say I have 3 columns; "Date", "Contact#", "Notes". Because of privacy restrictions, the information in the cells of the "Contact #" column need to be deleted once their corresponding entry date in the "Date" column reaches 20 days past it's date. I do not, however, need the "Date" column...
    • MJ72
    • Thread
    • cell clear based on date cell delete date
    • Replies: 4
    • Forum: Excel Questions
  2. M

    Prevent cells being deleted using VBA

    Hi all, I am in need of a VBA macro to stop a section of cells (F28:J36) from being deleted from a specific worksheet as they have important formulas in them. But I need the cells to be editable. I currently have simultaneous code which automatically hides the rows based on certain conditions...
    • Milos
    • Thread
    • cell delete cells deleted prevent cell delete vba
    • Replies: 1
    • Forum: Excel Questions

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