score:3
Accepted answer
Dim r As Range
Set r = Sheets("Sheet1").Range("A1:N100") 'change to suit
r.AutoFilter Field:=14, Criteria1:="<>-" _
, Criteria2:="<>", Operator:=xlAnd
Source: stackoverflow.com
Related Articles
- Filter to exclude formula and blank
- Exclude Non-Working Hours Using NetworkDays.Intl As A Complex Formula In Excel VBA?
- First blank ("") cell in column with IF formula
- VBA use filter to exclude item in string array
- Regular expression for cell formula to exclude units
- Open File Dialog with exclude Filter (Excel VBA)
- Advanced Filter does not recognize blanks returned by a formula
- How to Freeze Top Row and Apply Filter in Excel Automation with C#
- How to determine the last Row used in VBA including blank spaces in between
- Excel telling me my blank cells aren't blank
- Clear filter from Table
- Excel Macro, inserting internationally valid formula during run-time
- Set formula to a range of cells
- filter out multiple criteria using excel vba
- How to find out if an entire row is blank in excel thorough vba
- Write a formula in an Excel Cell using VBA
- Insert an Array Formula via VBA
- Fill formula down till last row in column
- How to get the range of the visible rows after applying an advanced filter in Excel (VBA)
- How to enter a formula into a cell using VBA?
- How do I copy a range of formula values and paste them to a specific range in another sheet?
- Excel is calculating a formula with a VBA function as an error unless it is re-entered
- Dynamically Adding Labels to User Form = Blank UserForm
- Filter Excel pivot table using VBA
- Remove blank rows in table
- Different languages issue when inserting formula from VBA
- Using Range.Replace on Formula Cells
- Access Filter VBA
- EXCEL VBA, inserting blank row and shifting cells
- Fill non-contiguous blank cells with the value from the cell above the first blank
- Check colour of entire column
- Auto Download Attachments and Rename using Sender's Name
- Sending R Markdown output as body email via outlook (RDCOMclient)
- Why do i get different output when i used the same code, same data but different laptops for vba?
- Input cell address, get table name
- Word 2010 VBA macro to restart numbered lists
- EXCEL VBA run formula via MACRO
- Create multiple combinations summing to 100
- ADODB SQL Syntax - Access table Inner Join with Excel worksheet
- Error creating PivotTable via VBA
- Why can't I use Call infront of DoEvents?
- Excel 2010 VBA- Loop If Then Statements
- regex interval with possible characters before and after number VBA
- Exporting SQL table to Excel - column names are not exporting, only the data
- Putting separate ranges into 2D array
- Question about CreateObject() in VB6 / VBA
- VBA - weird problem with control font on UserForm
- Sort Order formula to alphabetise in Excel
- Excell vba array loop inside another loop
- Excel VBA - Combine rows with duplicate values in one cell and merge values in other cell
