Hi Sharon:

It appears that there is a limitation on how many discontinuous areas you
can include in a named range.

Regards,

Vasant.

"Sharon" wrote in message
...
I select 44 areas of nonadjacent cells on one worksheet
and give them one name.

Then I try to clearcontents this way:

Sub MakeDeletions()
[Period2].ClearContents
End Sub

Only 31 of the areas clear. 13 still have the data in
them.

I can't seem to find anything on this limitation so
perhaps it is my mistake? Assuming it was me, I kept
deleting the range name and trying to select it very
carefully again - several times. It lets me create the
name but when I attempt to clear it - that's where the
problem occurs.

Thank you-