Help with error

  • Thread starter Thread starter WLMPilot
  • Start date Start date
W

WLMPilot

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
 
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 variablesan
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
Click to expand...

Could be a number of problems e.g. look for merged cells which XL
doesn't like to sort.
AP
 
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]
 
Back
Top