for each rg in range("c1:j1")
k=false
for n= 1 to len(range("a1"))
if instr(rg,mid(range("a1"),n,1)>0 then k=true
next n
if k=false then rg.clear
next rg
for each rg in range("c1:j1")
k=false
for n= 1 to len(range("a1"))
if instr(rg,mid(range("a1"),n,1)>0 then k=true
next n
if k=false then rg.clear
next rg