Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Force content in closed workbook
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value from a closed workbook | Excel Discussion (Misc queries) | |||
How do I force a reload of the workbook? | New Users to Excel | |||
How do I clear cell content when excel document is closed? | Excel Worksheet Functions | |||
Possible to copy sheets into another (closed!) workbook? | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |