Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advancedfilter copy in place doesn't use criteria range correctly
I'm going a little crazy. If I run an advancedfilter in the vba code of my
userform command button it builds the criteria range correctly (I can stop at a breakpoint, look in excel and see the right criteria range), but when the advancedfilter runs it returns the full list as if it ignored the criteria range or it hides all rows in the input range (if I do it manually). Please help, I can provide code if needed. Thanks Josh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advancedfilter copy in place doesn't use criteria range correctly
Is the worksheet name included in the criteria reference? Perhaps it's
using a range on the active sheet when you run the code. Josh wrote: I'm going a little crazy. If I run an advancedfilter in the vba code of my userform command button it builds the criteria range correctly (I can stop at a breakpoint, look in excel and see the right criteria range), but when the advancedfilter runs it returns the full list as if it ignored the criteria range or it hides all rows in the input range (if I do it manually). Please help, I can provide code if needed. Thanks Josh -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
Using AdvancedFilter on range of data | Excel Discussion (Misc queries) | |||
Place X in cell if criteria met` | Excel Discussion (Misc queries) | |||
Copy a range from different worksheets and place in another worsheet | Excel Programming | |||
AdvancedFilter Criteria question | Excel Programming |