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