Open both workbooks. Select the cell in the first workbook with the
formula you want to copy. Place your cursor on the Formula Bar at the
top of the sheet and click and drag to highlight the entire formula.
Press Ctrl+C (to copy) then press the Esc key to deselect that cell.
Now go to the cell in the second workbook and press Ctrl+V (paste).
Done!
HTH
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=398581