-
Copy from Active workbook to opened Master Workbook
Hi Everyone,
I have a active workbook that I want to copy some data from the activesheet. The macro will be run from the master workbook which is c:\excel\masterwb.xlsm. Both workbooks are already opened. How do I create a macro to copy eg. Cell G5 from the activesheet to sheet1 of the master workbook? Any Help is appreciated.
-
For example:
[vba]application.activesheet.range("G5").copy destination:=thisworkbook.sheets("Sheet1").range("G5")[/vba]
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules