thank you,Mark. My drop-down list is really large, almost 50 rows. My question is, I have to get configuration from database, then create this excel-file, Maybe, there are two columns need drop-down list, maybe ten cols, it depends who config the template in our system. Do you think it's possible to do it with your solution? Anyway, you provide a useful way, appreciate you very much...
Regards, Mead On Thu, Feb 23, 2012 at 4:34 PM, Mark Beardsley <[email protected]>wrote: > CellRangeAddressList(0, 0, 0, 0) - to make the drop down appear
