Maybe use SpecialCells(xlCellTypeBlanks) to find the empty cells and lock
the column then unlock those

--
HTH

Bob Phillips

"programmingrookie" wrote in
message ...
Within a single column, how would I set a range to be just the cells that
have data? I want to lock these cells using a change event, while leaving
the remainder of the cells editable. I'm trying to set one range as the
entire column, and a second range as cells with data, then using an
intersect
to lock the cells with data. This should allow for continuous locking of
newly used cells.