Clearing unlocked cells

Resolved · Low Priority · Version 2003

Wed 22 Sep 2010, 12:13 Delegate Catrin said...

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

Tue 28 Sep 2010, 14:17 Trainer Jacob said...

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

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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