You're welcome

>Thanks Sergey!
>
>
>>

>>oSheet.Columns("J").ClearContents()
>>

>>
>>>
>>>I have an object reference to an Excel file and am extracting various data that I need from it. How do I clear the contents of a column of data, eg column J?
>>>
>>>TIA