Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error 1004 - metod Copy of class Range was failed
If your code is being executed from a commandbutton from the control toolbox
toolbar, then set the TakeFocusOnClick property of the commandbutton to false. -- Regards, Tom Ogilvy "M." wrote in message ... I'm using Excel 97. My code stoped on this line of code: Worksheets("PROGRAM").Range("26:26").Copy Destination:=Worksheets("SEZNAM UO").Range("1430:1430") Active worksheet is "PROGRAM"! I'd like to copy entire row witch location has writen in variable from one worksheet to another with diferent row number. Thank's on advice! Milos |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
error 1004 - metod Copy of class Range was failed
Tom, thank's!
you gave me idea how to solve this problem, with takefocusonclick i did not solve my problem, but with activating one cell on worksheet! Regards, Milos "Tom Ogilvy" wrote in message ... If your code is being executed from a commandbutton from the control toolbox toolbar, then set the TakeFocusOnClick property of the commandbutton to false. -- Regards, Tom Ogilvy "M." wrote in message ... I'm using Excel 97. My code stoped on this line of code: Worksheets("PROGRAM").Range("26:26").Copy Destination:=Worksheets("SEZNAM UO").Range("1430:1430") Active worksheet is "PROGRAM"! I'd like to copy entire row witch location has writen in variable from one worksheet to another with diferent row number. Thank's on advice! Milos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
Error 1004 Copy method of worksheet class failed | Excel Discussion (Misc queries) | |||
Runtime 1004 error -- insert method of range class failed. | Excel Discussion (Misc queries) | |||
Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) |