Catrin has attended:
Excel VBA Advanced course
Clearing unlocked cells
Hi,
I have a locked sheet, with a range of cells called "EmissionRows" (rows 20-25 say)
I have some cells which are unlocked within this range, and I would like to clear the contents of these after clicking on a command button on the sheet.
I know that the following code will clear the contents of all cells within a sheet (but I only need to do it for cells within the range):
On Error Resume Next
ActiveSheet.UsedRange = ""
On Error GoTo 0
Thanks
Catrin
RE: Clearing unlocked cells
Hi Catrin
Thanks for your post. It is a bit tricky to provide a solution without seeing your working files first.
If you can reply to my email I can get one of my colleagues to review this, they are next in on Thursday.
If we find it is a quick fix we will advise you of this and complete it for you. However if it transpires that more time needs to be invested then it is beyond the scope of this forum as we will need to allocate specific trainer time.
We will advise if this is the case and let you know scope of work with associated durations and costs.
regards
Jacob
