Excel vb Filter
Posted by Joseph Was on April 18, 2001 3:47 PM
Return row which in one col. has a 7 digit code with 1,000's of possible codes, filter by a wild card filter.App.InputBox gets search criteria, like: UB?????. Look in code col. then return row's from sheet which meets criteria on a new sheet.
Each time the Filter(SourceArray:=Scode, Match:=Temp, include:=True, compare:=vbTextCompare)=Stest gives miss-match data type, also tried AdvancedFilter, named ranges, explicit ranges, subs, ect. can't get it to work?