D delta Member Mar 14, 2017 #1 i upload file i want set to validation range in sheet "Data" will be A1:A100 how to i change the validation range in code with sheet Data then nothing is done how to set range sheet Data A:A100 Attachments validation_2.xlsm 21.6 KB · Views: 3
i upload file i want set to validation range in sheet "Data" will be A1:A100 how to i change the validation range in code with sheet Data then nothing is done how to set range sheet Data A:A100
Ramesh Active Member Mar 14, 2017 #2 You can write the following expression in the Data Validation dialog box: Code: =Data!$A$1:$A$22
B bosco_yip Excel Ninja Mar 14, 2017 #3 In sheet "Data", select range of cells >> Data Validation >> >> Allow, select : List >> Source, enter formula: =OFFSET(Data!A1,,,COUNT(Data!A:A)) Regards Last edited: Mar 14, 2017
In sheet "Data", select range of cells >> Data Validation >> >> Allow, select : List >> Source, enter formula: =OFFSET(Data!A1,,,COUNT(Data!A:A)) Regards
