View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MarkyB MarkyB is offline
external usenet poster
 
Posts: 12
Default Data Validation by List

Found the problem to be when I insert enough rows prior to copying List
Validation cells. Will work on that to solve issue.

"MarkyB" wrote:

I have a number of cells that use Validation by List. When a user clicks a
button, these cells are copied and inserted below. How can I turn off
Validation by List for these newly inserted cells?

Thanks,

Mark