How can I restrict my macro to a range of unlocked cells rather than the whole sheet?

[mltornroth]

I've got a form that mayy be used several times throughout a user's day. Each time it is filled out and saved or sent, it will need to be cleared. I've got a macro to clear the form by changing all unprotected cells to a null value. Trouble is, I would like to omit just one cell from all of that. The cell is unprotected but it's a drop down and I want it to default to a value. Can the following code be restricted by column or print area? (The cell I want to avoid is outside the print area or if by column, I'd like to clear all unprotected cells up to but not past column 'AM')

Please Login or Register  to view this content.

Thanks for the help

[royUK]

Instead of UsedRange, selct all the cells to be deleted & create a Named Range which excludes the cell you want to keep. Use that named range in the macro

[Ace_XL]

Instead of not clearing this umprotected cell (say AP10), why dont you re-type the 'default' value. An adaptation of the below..

Please Login or Register  to view this content.

[mltornroth]

Thank you both for replying.

Roy - I tried that but it seems that since I have merged cells it won't let me define a range consisting of all of these unprotected cells. It will but win it goes to clear them it wants to look at only the first cell of each and not the merged collection, which causes an error.

Ace - The concept is perfect. So, if I understand correctly, this would reset the cell I want to preserve to its default. Where would I designate its default though? (Its a drop down list and the value I would like to 'default' is the first of three values in a list.

Thanks again to both of you.

[royUK]

Always avoid using MergedCells, use Center across selection.

[Ace_XL]

Substitute in post #3

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

assuming your drop-down list options are listed in Cells X1,X2,X3