I would like to be able to check (without use of Exception Handling) to see if a single cell's Value/Value2 Property can be changed or not.
For example I will not be able to change a cell's value if the cell is Locked and its parent worksheet is Protected.
I also won't be able to change a cell's value if the cell is part of an Array formula than spans multiple cells.
Also certain cells within a Pivot table cannot have their Value/Value2 property changed.
I am sure there are other cases that I have not thought of as well.
Does anyone know of a custom or built-in function or Range property that achieves this? Ideally I would like a solution that does not use Exception Handling (OnError statements).
For example I will not be able to change a cell's value if the cell is Locked and its parent worksheet is Protected.
I also won't be able to change a cell's value if the cell is part of an Array formula than spans multiple cells.
Also certain cells within a Pivot table cannot have their Value/Value2 property changed.
I am sure there are other cases that I have not thought of as well.
Does anyone know of a custom or built-in function or Range property that achieves this? Ideally I would like a solution that does not use Exception Handling (OnError statements).
