Hi guys! Taking my first steps in working with arrays. I'm trying to load a dynamic array as an autofilter criteria, but I must be missing something. Found some hints Googling around, but couldn't make it work. I will get the filter marker in the right column, but no filtering results. Array is...
Firstly: all this is for a dynamic table called StockListTable.
I have a Column (Header = Owner) containing numbers representing customer numbers (1 to 150 plus 998 and 999).
I wish to filter out the following customer numbers---0, 27, 72, 84, 100, 998 and 999---thus leaving all...
So thanks to a number of kind people here, I have been guided and helped a number of times. Thank you to those that have done so and been patient with my questions as well as lack of understanding. I am learning and your guidance challenges me to learn me. Thank you!
I have a scenario where I...
I’ll start with my spread sheet layout and explain in steps what I’m trying to achieve, I will then say what I’ve tried code wise so far but everything I have put together so far fails
My small version of my spread sheet is attached the full spread sheet is 17MB and alot of rows...
Is there a way to use a 'not' with an array in autofilter?
I'd like to show all rows excluding those in the array.
see below code:
Dim lr As Long
lr = Cells(Rows.count, 1).End(xlUp).Row
Range(Cells(1, 1), Cells(lr...
After a couple of research I found a code that in theory works with an array of values that define the filter criteria to work with, when I tested as I download it it worked, however when I change those to the values I need, the filter result went blank, so this where I need the assistance I...
I am using an auto filter criteria range, where the cells reference filter selections input on a different tab. For example, the cells in the criteria range have a formula similar to this:
However, if only 1 of the 4 input selections are chosen (which is often...
Can anyone tell me if it is even possible to use a dynamic range as an autofilter criteria? I tried with the below code and it does not work..a close variation also gets my Excel to crash
Dim var As Integer
I have an autofilter setup with 3 values: "Show", "Hide" and "Always". The show/hide values are dependent if formulas based on other cells.
I have two sheets with this filter (Template and Summary); the filter works fine on the Template tab, however on the Summary tab...
When filtered to...
Could someone please explain to me why the following does not work?
ActiveSheet.Range("$A$1:$Z$5000").AutoFilter Field:=8, Criteria1:=Array("*New_Company*"), Operator:=xlFilterValues
New_Company is a variable of type String that takes different values via an InputBox
I have searched all over looking for the solution without any luck. I have a filter that needs an array that has 3 criteria that I do not want to pull in my filter. Here are the ways I have tried to get this to work without success.
Selection.AutoFilter Field:=3, Criteria1:=Array( _...