I want to write one macro for checking the values in the column. i.e I
there is any value in the B1 cell, then it should take copy that valu
somewhere else and move to B2. If again that value is there then i
should take it and move next...like hat I want to check all tha valye
of column

--
reen
-----------------------------------------------------------------------
reena's Profile: http://www.excelforum.com/member.php...fo&userid=3044
View this thread: http://www.excelforum.com/showthread.php?threadid=50243