ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error when moving sheet (https://www.excelbanter.com/excel-programming/316202-error-when-moving-sheet.html)

mihai[_6_]

Error when moving sheet
 

The problem was that I did not shown the exact way. It works like this:

Workbooks("qsar_z.xls").Sheets(1).Mov
After:=Workbooks("qsar_detaliu.xls").Sheets(1)

As you can see I was so desperate that I even changed the names of th
files. :)
Stupid mistake

--
miha
-----------------------------------------------------------------------
mihai's Profile: http://www.excelforum.com/member.php...nfo&userid=280
View this thread: http://www.excelforum.com/showthread.php?threadid=27660



All times are GMT +1. The time now is 12:11 AM.

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