Hi again guys:

In a bit of a jammed here,
Again this is the best site I turn to, for help.
I paste down my script below for your easy viewing. (it's a sample, overall I have 10 comboboxes)

I don't have any prob when all of the comboboxes are selected (not equal to blank). it works beautifully.
But when I leaved some blank. Then the filter doesn't worked.

Thank you in advance for your kind help.


last = Cells(Rows.Count, 4).End(xlUp).Row
For i = last To 1 Step -1
If Cells(i, 4).Value = combo1 And Cells(i, 5).Value = Combo2 And Cells(i, 6).Value = combo3 Then
Cells(i, 4).Select
Range(Cells(i, 3), Cells(i, 24)).Select
Selection.Copy
nextrow = Range("z5000").End(xlUp).Row + 1
Cells(nextrow, 26).Select
ActiveSheet.Paste
Application.CutCopyMode = False

End If
Next i