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.