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. |
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 |
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. |
All times are GMT +1. The time now is 11:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com