y88886666c

Thanks Boki (Berg).

    The 1st Question is :  the one line bgcolor is clRed, another line bgclor is clGreen, next  line bgcolor is clRed, next  line bgclor is clGreen,   clRed, clGreen, ......

    The 3rd Question is : example column(2)  value has 'A' or 'B' or 'C',    use col.Filter='A' can only display column(2) string equal 'A'  cells, how set can i to only disply column(2) string equal  'B' or 'C' , without 'A'

Look forward to your reply