Thanks Biff, Peo Sjoblom, and Max!!!
Could you guys or anyone out there explain what do field=1 and
criterial=1 in this line mean:
Selection.AutoFilter Field:=1, Criteria1:="*" & UserVal & "*"
I tried to further improve my worksheet where user can choose which
column to perform the search--field_1 or field_3.
If user chooses field_1 then the search function will only search
related string in column field_1 and vice versa.
Can excel bolded the search string in the output??
And how to fit the worksheet into related columns and eliminate the
un-used area.
Thanks in advance.
YJL
--
YJL
------------------------------------------------------------------------
YJL's Profile:
http://www.excelforum.com/member.php...o&userid=28693
View this thread:
http://www.excelforum.com/showthread...hreadid=484200