hmmm.its ok but i want to learn vba.i could not loop each cell perfectly.so was looking for the same....pls help me..