Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with error
I have a worksheet with 12 months of budgets. I wrote a macro that is
suppose to copy the most recent budget year to the new year. It then executes several commands in an effort to initialize the new worksheet. One of the routines is a sort. This sort was copied from another routine and pasted into this macro. It works in the other routine. The only difference is that this sort is now in a For/Next loop (since I have to process 12 budgets) and therefore I had to make a couple of the variables an array. The error I get is this: Run-time error 1004 Select method of Range class failed. Any ideas? Thanks for any help on this, Les |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with error
On Jan 4, 11:23*am, WLMPilot
wrote: I have a worksheet with 12 months of budgets. *I wrote a macro that is suppose to copy the most recent budget year to the new year. *It then executes several commands in an effort to initialize the new worksheet. One of the routines is a sort. *This sort was copied from another routine and pasted into this macro. *It works in the other routine. *The only difference is that this sort is now in a For/Next loop (since I have to process 12 budgets) and therefore I had to make a couple of the variables an array. The error I get is this: Run-time error 1004 Select method of Range class failed. Any ideas? Thanks for any help on this, Les Could be a number of problems e.g. look for merged cells which XL doesn't like to sort. AP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with error
If you are using the Select method to Select some cells, you need to
be aware that you cannot Select cells that are not on the Active Sheet. For example, if Sheet2 is active, the statement Worksheets("Sheet1").Range("A1:A10").Select will not work because Sheet2, not Sheet1 is active. If you must use Select, and it is rare that you really need to do it, you should Select the worksheet first, then the range: Worksheets("Sheet1").Select Range("A1:A10").Select Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Sun, 3 Jan 2010 14:23:02 -0800, WLMPilot wrote: I have a worksheet with 12 months of budgets. I wrote a macro that is suppose to copy the most recent budget year to the new year. It then executes several commands in an effort to initialize the new worksheet. One of the routines is a sort. This sort was copied from another routine and pasted into this macro. It works in the other routine. The only difference is that this sort is now in a For/Next loop (since I have to process 12 budgets) and therefore I had to make a couple of the variables an array. The error I get is this: Run-time error 1004 Select method of Range class failed. Any ideas? Thanks for any help on this, Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |