multiplesheetscode

  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. pedie

    Need help running code in all the worksheets except 4 of then out of 12. Thanks

    I have code that was shared by Peter, but i want the code to run on all the worksheets except on Sheets("KData", "HGData","GData","VData") Thanks for helping! Sub try1() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Name <> "Home" Then 'mycode End If Next...

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