Nigel,

See my reply to your other question in excel.misc, but you'll need the
workbook open.

--
HTH

Bob Phillips

"Nigel" wrote in message
...
Can you force a content or item into a closed workbook with a receiving
formula?

example:
copy C2 contents and paste them into R45 in a closed book?

i am having trouble with carrying over a variable between 2 macros. i need
(
in macro 1, to select and copy the contents of C2 and in macro 2 ( on
another
workbook ), use the value to carry on its procedure. Can this be acheived?

Regards,

Nigel