Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button failure
Why does the following fail @ Range("D2").Select
Rum-time error '1004" Application-defined or object-defined error If I run the exact same code in a Macro it works fine Private Sub CommandButton1_Click() Workbooks.Add ActiveWorkbook.SaveAs Filename:="TempData.xls" Windows("testbook.XLS").Activate Range("D2:D7").Select Selection.Copy Windows("TempData.XLS").Activate Range("D2").Select ActiveSheet.Paste End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button failure
Hello!
I change one row, and it works me! Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect Regards Kari J Keinonen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button failure
When I replace "Windows("TempData.XLS").Activate" with
Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect I get a 1004 "Select method of Range class failed" at this new line oldjay "Kari J Keinonen" wrote: Hello! I change one row, and it works me! Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect Regards Kari J Keinonen |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button failure
Hy!
I don't replace that row. Regards Kari J Keinonen "Oldjay" wrote: When I replace "Windows("TempData.XLS").Activate" with Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect I get a 1004 "Select method of Range class failed" at this new line oldjay "Kari J Keinonen" wrote: Hello! I change one row, and it works me! Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect Regards Kari J Keinonen |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button failure
What row did you replaced??
"Kari J Keinonen" wrote: Hy! I don't replace that row. Regards Kari J Keinonen "Oldjay" wrote: When I replace "Windows("TempData.XLS").Activate" with Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect I get a 1004 "Select method of Range class failed" at this new line oldjay "Kari J Keinonen" wrote: Hello! I change one row, and it works me! Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect Regards Kari J Keinonen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup failure & ctrl-f failure? | Excel Discussion (Misc queries) | |||
VB's Command Button vs Form's Command Button | Excel Programming | |||
Command Button Macro Execution Failure | Excel Programming | |||
OnAction command failure | Excel Programming | |||
Command Button vs Control Button | Excel Programming |