ok, now I see what I'm missing. appreciate your help.
another issue: :) if I change the following line
Columns(2).Formula = Columns(2).Value
to
rng.formula = rng.value

it won't work.
could you tell me why?


sorry to bother you agai

--
xian
-----------------------------------------------------------------------
xiang's Profile: http://www.excelforum.com/member.php...fo&userid=2948
View this thread: http://www.excelforum.com/showthread.php?threadid=49259