excel - Excel Combobox ListFillRange RC adressing

Question

I need to populate an Excel combobox via Properties - Combobox window, ListFillRange property (NOT through code). I am able to do it if I put in A1:A10, but I need it in RC style. (1,1);(1,10) style. Is it possible? How?

标签： excelcombobox

Answer 1

All they need to do is enter it as say Sheet1!R1C1:R10C1 and Excel will automatically change it to the relevant A1 style address