98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Clearing unlocked cells
Clearing unlocked cells
Resolved · Low Priority · Version 2003
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
Tue 5 Oct 2010: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:##### displaying in ExcelWhen you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake. |