hi,

i have the following:
If Application.WorksheetFunction.CountIf(Range("L1:L" & j), Range("L" &
j).Text) 1 And Range("L" & j) < "" Then

this works in other sheets, but i did some comparison to te other sheets and
found out that the other sheets do not contain values greater than 200
characters in the column L. How can i amend or fix this?

thanks in advance,
geebee