formula1 dont work on add_data_validation

[paulomcnally]

I create formula on Excel UI and work. But use formula1: '=INDIRECT(INDIRECT("C"&MID(CELL("address"),4,1))&"!A$2:A$30")' and dont work. The excel file generated is corrupted.

Any idea?

=INDIRECT(INDIRECT("C"&MID(CELL("address"),4,1))&"!A$2:A$30")

[vsolari]

Hola Paulo, lograste agregar la formula en formula1 ?