|
Swink posted:I want to know if its possible to select more than one item from a criteria when using the autofilter. Yeah, go to "Custom" in the list. In the example, you set the first one to equals oranges, the radio button to "or", and select apples in the second.
|
# ¿ May 26, 2009 17:09 |
|
|
# ¿ Apr 28, 2024 10:40 |
|
Here's what appears to be an annoying Excel 2007 bug. Got a pivot that's created each time using VBA, so it's not a case of cached data that's not there any more. Got a form where the combobox is populated using the pivotitems from the pivotfield, so it's not a case of the filter not actually being in the pivotfield. Try and set the visible property of the pivotitem, and it throws a fit. Basically, if you've got a pivotitem that's a UK format date (dd/mm/yyyy), it seems impossible to set a load of the properties. Throws up error 2042 instead. Can still get at the name, caption, etc, just not the properties I need. Ooooooooooooooh, thinking about this, I wonder what would happen if I set the name to something else to start with, then tried to set the visible property?
|
# ¿ Sep 9, 2009 11:33 |
|
MattWPBS posted:Ooooooooooooooh, thinking about this, I wonder what would happen if I set the name to something else to start with, then tried to set the visible property? For anyone who runs into the problem, this works. Added "str" to the front of the name at the start, took it off at the end after setting the visible property. Bloody 2007.
|
# ¿ Sep 10, 2009 14:33 |