Module that exports to Excel: Formatting question 2

[MyaCCt]

Hello all,

I have a module that exports a query to Excel. It's a very nice little thing (thanks, in no small part, to the help I've gotten here). Anyway, I'd like to have a layer of formatting so that the first column is filtered (the little arrows show up without the user having to click on the top cell and click Formatting/Filter). How and where would I put that? I tried xlApp.Selection.AutoFilter and that's not it. Or maybe it is and I'm putting it in at the wrong step.

Thanks!
-Mya

 

[MyaCCt]

Wouldnt it figure... I posted and kept trying different things/different locations, and I've gotten it. Sorry!

xlApp.Range("A1", "I1").AutoFilter

 

[Andrzejek]

You may also try:
[tt]
xlApp.Cells.AutoFilter[/tt]

This will work no matter how many columns you have.

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[SkipVought]

I'd prefer

xlApp.ActiveSheet.UsedRange.AutoFilter

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]