Force content in closed workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Nigel,

See my reply to your other question in excel.misc, but you'll need the
workbook open.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

run macro on workbook close 3
Issuing macro in workbook from separate workbook 1
sumif using other cell contents as workbook 3
Macro to push data to another workbook 0
How to copy a range of cells and paste into a new workbook in differentcolumns 3
Locked for Editing 5
Macro to open, Update links, save and close workbooks 0
force excel workbook to open to a specific worksheet 1

Back
Top