>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.
If it's not broken, fix it until it is.
My Blog