This works for me. I have 17 columns, I want 1,3,4,6,8 to be text and the rest General.
Dennis Mello
Imports Excel.XlColumnDataType
Dim columnarray(,) As Integer = New Integer(,) {{1, xlTextFormat}, {2, xlGeneralFormat}, {3, xlTextFormat}, _
{4, xlTextFormat}, {5, xlGeneralFormat}, {6...