clearcontents button

  1. L

    Clear multiple range contents, multiple protected sheets, vba

    I have some code that works great. However, I need to add in another range of cells to be cleared on a different sheet. Sheet names are "Sheet1" and "Hidden". The ranges that need to be cleared on the Hidden sheet are A2, A5, A14. Sub ClearCells() ActiveSheet.Unprotect Password:="232323"...
  2. C

    How do I add a "do you wish to continue" warning message and bring blanks to bottom of table when creating a clear button for certain cell values?

    I am making a funnel management tool and I am trying to use .AutoFilter to clear contents in a row on Table 1 if it states "installed", "scheduled", or "cancelled in the "stage" column. I do not want to delete the rows entirely because I want to keep the number of rows in the table as 100. I...
  3. C

    Clear contents in table based on certain words in last column

    Hello all! I am extremely new to VBA, so my question may be dumb or simple, but I haven't been able to find the answer anywhere... I am trying to make a sales tracker with a table range from A2:G103 including headers. Column G in that table will include a dropdown to select options such as offer...
    • cheesypoofs
    • Thread
    • auto filter clear rows based on certain data clearcontents button clearcontents from range vba
    • Replies: 2
    • 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