Hi Garry,

Thanks for your help. I will take a look your link. For the second part, I used
oSheet.Range["A1"].Value = "Value", it does not work. Howevr, the same syntax works for regular cells (cells that don't have a dropdown associated with). Thank again.

Hugh