for each c in range("a2:a22")
if len(c)20 then msgbox "Bingo"
next c

--
Don Guillett
SalesAid Software

"pmms" wrote in message
...
I know I have to use LEN in a loop but I don't know VBA and need this info
asap. can you help?