select Case cells(1,i).value
case"aaa","bbb"
columns(i).delete shift:=xlToleft
end select