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