>>loRange = loSheet.UsedRange.Offset(3,0)
>>loRange.columns[m.lnK].NumberFormat = taHeader_Info[m.lnK,3]
>>
>>Cetin
>
>Works great, thanks a lot. The only other thing I'd like to apply to my Excel file is to highlight totals in different color. I'm not sure how to apply this after the file with data is already created.

Sorry I don't understand what you mean.
Cetin