You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Excel VBA AutoFilter

Excel VBA AutoFilter

Price: FREE

I have an autofilter for which I set a filter "Contains" based on a combobox that contains a Year value. So the combobox will have 2001 in it and will filter my spreadsheet for any cell containing 2001.
Here is the code used to do the above:
Sheets("Sheet1").Range("$B$2:$K$499").AutoFilter Field:=9, Criteria1:="=*" & cmbYear & "*", Operator:=xlAnd
Now what I want to do is allow the user to enter a set of years, ie 200-2005. When the user enters the value 200-2005 in the combobox it will set the autofilter to list any cells that contain 200, 2001, 2002, 2003, 2004, 2005.
How can I make this happen? Im sure there is some way with an array, but my knowledge of arrays on a scale of 1 to 100 is about 5.

Visit publisher's web-site: Excel VBA AutoFilter

Category and Tags: ExcelTutorials : : VBA

Related Tutorials

VBA help on .AutoFilter results

Free: Yes
Tags: Excel ›

I'm able to create the .AutoFilter using VBA, but I haven't a clue how to:
(1) Find out if the .AutoFilter method produced any results or not,
(2) Navigate to the top row of the range, and
(3) Advance from row to row.
I need to use the values in each cell to initialize a numeric variable for use in an accounting application. I'm using Excel 2K3 with Windows XP.

Autofilter Select all with VBA

Free: Yes
Tags: Excel ›

I have an autofilter in a worksheet and I would like to use a button to clear the filter (ie select all records), but not delete or remove the actual autofilter. What code in VBA can be used to clear the filters and make it so all records are showing?

AutoFilter question

Free: Yes
Tags: Excel ›

Via a cell formula (vs. using VBA), how can I populate a cell with the first value found after an AutoFilter has been applied?
For example, A1 contains the column header. A2:A11 contain the cells to which the AutoFilter will be applied. Let's say I apply the AutoFilter and get data in A3, A8 and A9. So, I would like G1 to be populated with the first value found after the AutoFilter had been applied, in this case the value from A3.

Removing BLANK option from autofilter

Free: Yes
Tags: Excel › VBA

Whenever we apply autofilter to a column, we get one check box for BLANK cell.
Is there any way to remove this option from drop down list of autofilter? Particularly via VBA?
Hope someone will be having a solution to this.

Autofilter range only

Free: Yes
Tags: Excel › VBA

Long time reader, first time poster. I have a rather simple question regarding setting an autofilter to a range of cells and ONLY that range. The below code can accomplish a range of cells, BUT! I want to keep the data below that range out of the autofilter.
Regular Range AutoFilter
With ActiveSheet
.AutoFilterMode = False
.Range("A1:D8").AutoFilter
End With
What I need is for the code above to filter that range ONLY and ignore the rows below the range. In the example below I want the totals row to be excluded from the autofilter.

Related Applications & Scripts

VBA Password Recovery Key

Free: Yes

VBA Key resets passwords to view Visual Basic for Applications (VBA) projects source code.
VBA is a Microsoft Office component and is used by such applications as Microsoft Excel, Microsoft Word, Microsoft Access, AutoCAD, etc.
Features:
State of the art password recovery engine - all files are unprotected instantly
All Office 2010/2007/2003/XP/2000/97 products are supported: Word, Excel, Access, etc. Updated!
Multilingual passwords are supported
Full install/uninstall support
Demo limitations
Demo version recovers passwords containing no more than 3 characters.

Add email account to a windows 2003 pop3

Free: Yes
Tags: ASP › Excel Emailing

Lets you add an user email account to windows 2003 pop3 service using script or other programming environment. The script bellow is written in VBA 6 (You can use it in Visual basic 6, Excel, Access, ...), you can simply modify the script for VB Script or VB.Net. The function uses P3Admin.dll and it's programming interface. You can manage the accounts locally or remotelly. You will need P3Admin.dll, P3Store.dll, Pop3Auth.dll, Pop3evt.dll, pop3perf.dll and pop3snap.dll DLLs (registerred using regsvr32)

febooti Command line email

Free: No
Tags: Software › Excel Emailing

Febooti Command line email client is powerful but easy-to-use email sending utility, which supports all of e-mail client sending capabilities.
With Febooti Command line email you can send mail directly from windows command line (DOS prompt). You can attach files to email, use HTML e-mail messages, use CC (Carbon Copy) and / or BCC (Blind Carbon Copy). Call Febooti Command line email from Scheduled Tasks, CGI scripts, VBA, virtually from any software, also can be used in automatic email tasks and MAPI replacement.

ActiveX component to generate sound in system speakers

Free: Yes

This component can be used for the generation of sound using system speaker by any applications that support ActiveX components: VBScript and Jscript, ASP (IIS), VBA for Access, Word and Excel, etc.
The component can be used by system administrator for the alert of predefined system events like port scanning, intrusion detection, applications running, read of specific pages or files, etc. The frequency and duration of sound can be set so that different sound patterns can be assigned to different set of events. Also a developer can use the component for applications debugging, i.e. testing ambiguous conditions, catching not handled exceptions, etc. ASP developer can avoid using response.write and Session variables for debugging and use predefined system sounds for a set of predefined events. You should use the component carefully since the execution of applications stops during sound.

.NET Remoting - SimpleIPC keeps it simple

Free: No
Tags: ASP › Excel Software

SimpleIPC is a set of objects, server processes, and configuration tools which allow you, the software developer, to have some of your application's work performed in an external process on the same machine. You make function calls to objects in the external process as if they were local objects. "Under the covers", you're using .NET Remoting over the IPC (Inter Process Communication) channel, but you don't need to be an expert on .NET Remoting to use SimpleIPC. The platform handles the communications and external process life cycle details for you. SimpleIPC runs on Windows, and the code to be run in the external processes (i.e. IPC servers) must be written in a .NET programming language. However, your client code may be written in a variety of languages, to include Java, VBScript/VBA, and .NET programming languages. In this way, SimpleIPC provides a straightforward interop between Java or COM and .NET.
You might consider using SimpleIPC under the following circumstances:
1. You have some code which is useful, but which has the potential to throw unhandled exceptions and crash your application process. You can run this code via SimpleIPC. If there is a process crash, it will be one of the expendable external processes, rather than your application process. Your application can just repeat the call against a different external process and continue on. There is no need for your end users to be impacted.
2. You have some code which is useful, but which leaks memory. You can run this code via SimpleIPC and configure the external processes to recycle frequently. In this way, you can keep your application's memory consumption under control without sacrificing functionality.
3. You need an expeditious way to perform one of several common programming tasks, such as invoking .NET code from a Java application, running a subset of your application's operations under a different Windows identity, or limiting concurrent access to shared resources in a multi-user environment.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing