Hello,

Dont know if this is the right thread but here it is.

I am writing an app using vb.net and I have exported some data into an excel
spreadsheet.

I know how to turn on the autofilter in VBA as well as format text.
However how do you turn on the autofilter from Visual Studio???

exSheet.AutoFilterMode = False
exSheet.Range("A1:L1").AutoFilter()

I have tried the above and I always get an exception on the second statement.
Also some help formatting text would be great.

Thanks!