Hi,
It's OK to copy the formula from one cell to another one within the
same sheet. How about that to copy the formula from one Excel file to
another one? It seems only the value of that cell will be copied to
that file but not the formula inside it. I even have tried to copy the
corr. formula within that again but just the copied formula will not
work successfully in there.

Thks & Rgds,
HuaMin


--
HuaMin
------------------------------------------------------------------------
HuaMin's Profile: http://www.excelforum.com/member.php...o&userid=29423
View this thread: http://www.excelforum.com/showthread...hreadid=491346