ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data Validation by List (https://www.excelbanter.com/excel-programming/402693-data-validation-list.html)

MarkyB

Data Validation by List
 
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

MarkyB

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



All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com