ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to copy a range to a closed workbook (https://www.excelbanter.com/excel-programming/304244-how-copy-range-closed-workbook.html)

max

How to copy a range to a closed workbook
 
Hi

Which is the syntax to copy a range from the open and active workbook
to a closed workbook (file)?

Regards.

Massimo
Bye

Frank Kabel

How to copy a range to a closed workbook
 
Hi
you have to open this other workbook within your code. You
may set
application.screenupdating=false
to prevent showing this other workbook to the user

-----Original Message-----
Hi

Which is the syntax to copy a range from the open and

active workbook
to a closed workbook (file)?

Regards.

Massimo
Bye
.



All times are GMT +1. The time now is 08:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com