| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy data code to work with seperate instance of excel
Hi this works if both workbooks are open in the same instance... however I
like to view both workbooks at once on two screens... Can this be adapted to work in a separate instance of excel? Both workbooks will be open when code runs Sub copyFA() Workbooks("FA Master").Activate Range("v19:v20").Copy ThisWorkbook.Activate Range("m3:m4").PasteSpecial xlPasteValues End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add two cells from seperate work sheets into a cell on seperate wo | Excel Worksheet Functions | |||
| Open files in seperate instance | Excel Discussion (Misc queries) | |||
| Copy data into new line on seperate sheet? | Excel Discussion (Misc queries) | |||
| Does anyone know how I can seperate a post code in my data sheet? | Excel Discussion (Misc queries) | |||
| Is it possible to export each row of data to a seperate work book | Excel Programming | |||
Threaded Mode
