ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy Data Validation (https://www.excelbanter.com/excel-programming/439603-copy-data-validation.html)

CLR

Copy Data Validation
 
XL2k....I have Data Validation in several (not all) cells from A1:J1.

When I change the value, or insert one, in any cell down column A, I would
like all that Data Validation information to be copied from row 1 down to the
activerow, without changing any values in the activerow. I can do it by
hand, but dont' seem to be able to get there with code. Any help would be
apprecaited.

Vaya con Dios,
Chuck, CABGx3




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

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