Copy from Active workbook to opened Master Workbook

[chlin]

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.

[Aflatoon]

For example:
application.activesheet.range("G5").copy destination:=thisworkbook.sheets("Sheet1").range("G5")

[chlin]

Thanks! It works.