malik641
12-12-2005, 08:50 AM
Hey guys (and gals) :)
In VBA, does the criteria for advanced filtering ALWAYS need a range...or is there a way I can define "Field Name" and "Value (for the field name)" without using a range?
I'm asking because I'm creating a userform to perform the advanced filtering and I don't want to have to write the field names and values to cells and then use that range for the criteria.
TIA
In VBA, does the criteria for advanced filtering ALWAYS need a range...or is there a way I can define "Field Name" and "Value (for the field name)" without using a range?
I'm asking because I'm creating a userform to perform the advanced filtering and I don't want to have to write the field names and values to cells and then use that range for the criteria.
TIA