Reply To: Data Validation Error

Home Forums 1. General Questions Data Validation Error Reply To: Data Validation Error

#58379
NowIC
Participant

I was able to upgrade to the Personal.XLSB from 2/10/2021, but still have the same error. I am not a macro programmer, but I was looking at the code and it appears that the columns that the macro should only be run in the Items…csv, not the Cost_Code….csv. based on the column numbers assigned by the macro.

Columns(“E:E”).Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=”Material,Labor,Equipment,Sub,Other”