阅读背景:

当从一个wb复制到另一个时,避免使用意大利面条代码。

来源:互联网 

Is there an alternative to using ActiveWorkbook and ActiveSheet in VBA when working with multiple workbooks (copying from workbooks in a list to a master sheet) ? It is turning out to be more confusing than anything to know which workbook is open when working with multiple functions which need to use different workbooks. Is it a matter of code organization ?Is there an alternative to using ActiveWorkbook




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: