clearing unlocked cells

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Clearing unlocked cells

Clearing unlocked cells

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

##### displaying in Excel

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

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Server loaded in 0.07 secs.