Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Move Method of Worksheet Class failed"
Hello!!
I get the error: "Move Method of Worksheet Class failed" when I write this instruction: Workbooks(gestion).Worksheets(plantilla_pedido).Mo ve After:=Workbooks(pedidosPend).Worksheets(indice) I've changed Move by Copy, but I get the same error with Copy. I have read this article in Microsoft but I don't find any solution. http://support.microsoft.com/default...84&Product=xlw May anybody help me? Thanks very much in advance!!! Regards, Marķa |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Move Method of Worksheet Class failed"
Hello Maria, I would check the Workbook Security levels first and then check if any of the Worksheets might be protected. If neither of those are problem then the problem most likely lies within the macro code somewhere. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=481810 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Move Method of Worksheet Class failed"
Note also that the article talks about copying a worksheet within the same
workbook which you are neither copying or working within the same workbook - so I don't think that article has anything to offer you. In fact, it suggest that copying from one workbook to another as a solution. As Leith has pointed out, there is nothing intrinsically wrong with the code - so the next thing to look at is your environment. Certainly if the destination or source or both workbooks are protected, this would be problematic. -- Regards, Tom Ogilvy "azurmendi" wrote in message lkaboutsoftware.com... Hello!! I get the error: "Move Method of Worksheet Class failed" when I write this instruction: Workbooks(gestion).Worksheets(plantilla_pedido).Mo ve After:=Workbooks(pedidosPend).Worksheets(indice) I've changed Move by Copy, but I get the same error with Copy. I have read this article in Microsoft but I don't find any solution. http://support.microsoft.com/default...84&Product=xlw May anybody help me? Thanks very much in advance!!! Regards, Marķa |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hello!!
Thanks very much for your suggestions. My intention is to move a sheet from a Workbook to another workbook. Both of them are unprotected. And my problem is that the error grows when I move the 100 sheet. Any idea? Thanks in advance!! Regards, Marķa |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Try moving them in groups rather than one at a time.
If your moving that many sheets, it may be easier to copy them all, then delete the ones you don't want, then delete the ones in the old workbook I can't really say since I don't know exactly what you are about, but you want to minimize the number of actions you take. -- Regards, Tom Ogilvy "azurmendi" wrote in message lkaboutsoftware.com... Hello!! Thanks very much for your suggestions. My intention is to move a sheet from a Workbook to another workbook. Both of them are unprotected. And my problem is that the error grows when I move the 100 sheet. Any idea? Thanks in advance!! Regards, Marķa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2003 "paste method of worksheet class failed" | Excel Programming | |||
Error Message "Select method of worksheet class failed" | Excel Programming | |||
"Copy Method of worksheet class failed" | Excel Programming | |||
VBA error 1004 "Select method of Range class failed" | Excel Programming | |||
Error 1004, "select method of range class failed" | Excel Programming |