Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filtering on an inactive sheet
i have a sheet that contains a database of products. Range("Products"). The
criteria range is above it ("FilterCriteria"). This sheet is not hidden, but is not active. i have a userform with a combobox to choose a filter criteria for the range. For some reason, when the sheet is not active, the filtering does not work. so does the sheet need to be active or is there a workaround? thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filtering on an inactive sheet
Yes, there are work-arounds. I believe it would help to know what you
want to do with the filtered data before suggesting one. Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filtering on an inactive sheet
On Apr 20, 3:48 pm, Spencer wrote:
i have a sheet that contains a database of products. Range("Products"). The criteria range is above it ("FilterCriteria"). This sheet is not hidden, but is not active. i have a userform with a combobox to choose a filter criteria for the range. For some reason, when the sheet is not active, the filtering does not work. so does the sheet need to be active or is there a workaround? thanks. Good evening Spencer, You'll want to ensure the appropriate range names are used in the advanced filter instead of cell references. For example, Range("Products").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= Range("FilterCriteria"), Unique:=False Using this technique, you will not have to select the worksheet containing the database/criteria for the filter to work correctly. Have a good weekend, Ray R. Gable, Jr. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filtering | Excel Discussion (Misc queries) | |||
advanced filtering | Excel Discussion (Misc queries) | |||
Advanced filtering | Excel Worksheet Functions | |||
Advanced Filtering | Excel Programming | |||
advanced filtering | Excel Worksheet Functions |