Is xlwings in python able to pass =INDIRECT as a formula when using ws.range(cell).api.Validation.Add?
looking for some guidance. I’m trying to add validation to a range of cells in a .xlsm file. I want to dynamically add validation to some cells in column C, dependent on whether a value is present in column A. My code seems to correctly create the dynamic name “EndorsementRange” as I can verify it’s in the .xlsm file, but the validation itself is failing. Here’s the relevant portions of the code: