Macros. Autofilter

[MindaugasBacius]

Hello,

I would like to filter out some values using Macros.

Unfortunately, I only manage to create a filter in excel but no luck with selecting the data in specified column.

How could I achieve my goals?

XLDoc.Sheets(1).Range("A1").AutoFilter

Thank you!

[marcus_sommer]

I hope it's helpful: http://www.ozgrid.com/VBA/autofilter-vba-criteria.htm

- Marcus

[MindaugasBacius]

I've come across this site yesterday. Sadly, I've tried a lot of variations but with no result.

[marcus_sommer · Accepted solution]

I think vbs goes straight through the order of parameters and didn't need / accept the parameter-names. I have now looked into a very old reporting of mine which worked at this time - here a snippet from them:

xlSheet.Activate

xlSheet.Cells(1, 1).Activate

xlSheet.Cells(1, 1).Autofilter 3, year(now() - 1)

xlSheet.Cells(1, 1).Autofilter 4, month(now() - 1)

xlSheet.Rows("2:" & xlZeile_1).Select

xlSheet.Rows("2:" & xlZeile_1).Delete

xlSheet.Cells(1, 1).Select

xlSheet.Cells(1, 1).Autofilter

- Marcus

[MindaugasBacius]

I did manage to do this!

XLDoc.Sheets(1).Rows("1:1").AutoFilter 13, "<>0"

Thank you Marcus for your professional help!