View Single Post
  #1   Report Post  
programmingrookie
 
Posts: n/a
Default Select Range of Cells

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.