RAP
You need to test the Locked property of the cells, e.g.
For Each cell in Range
If cell.Locked = False Then
cell.ClearContents
End If
Next cell
--
HTH
Simon
"RAP" wrote:
Hello,
Can anyone give me the VB code to select all the unlocked-only cells on a
page or in a defined range, to clear them?
Thanks,
Randy