Hi AB33,
Thanks very much.
This works great.
If I want to add another condition then what will be the code?
I tried but it will not work. e.g. condition 'cc' & 'aa'

.AutoFilter 3, Criteria1:="cc", "aa"