clear cells macro

Hello, A quick question I am wondering if somebody can answer. I have a range of workbooks each with 24 Sheets. I want to delete a specific set of cells with in each worksheet within each workbook - A10015 to AC10254 I have tried two options - but neither seems to work on all sheets in the...

Can anyone help me with a macro to cycle through my entire workbook and clear all the unlocked cells. Many thanks.

Hi everyone hopefully this is a simple one but my limited VBA experience has me stumped. I want to clear the contents of columns a and b when a is blank. Below is the table of sample data i want to clear cells a4:b7, however this range need to be dynamic based off if column A is blank and b...

Hi I have a column with the dropdown list option of just blank or "X" for each cell in that column. I want to be able to make it work so that if a cell, say A3 has an "X" in it then all other cells in the column are cleared/blank - Except the Header Line in A1. If another cell, say A12 is...

I am trying to reset/clear multiple sheets in an excel document as well as resetting the toggle buttons to "True". I can get the information to clear from all sheets and the toggles to reset on the active sheet but can't get the toggles from the 2 others sheets to reset. My clear button is on...

Hello all, I have an Excel file which I use to manually enter information about a group of co-workers, which looks like this: In the first column, from A12 to A26, I have a list of names. In the range E12 to Z26, I then manually enter the necessary information as needed. What I would need...

I set up a worksheet for other users to calculate the tax consequences of different divorce settlements. The users enter the cells bordered in black. The cells bordered in blue return results and are the cells I want to lock (and to do this I need to protect sheet.) I want the users to be able...