If you want to copy VBA press Alt + F11, then copy the code and paste it
where you want it. Or save the macro code as *.bas and import that file also
from the VBE. There is no macro code in a cell. If you mean formula, then
copy from the formula bar and it won't screw up your references or replace
the equal sign with something unique like ^^ and copy all the text strings
using copy and paste and do a reverse edit and replace after you have pasted
it
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
