Having problem with a nested FOR loop

[GIS2013]

Hi, I'm trying to run a nested loop, but receiving an error message. I'd much appreciate if somebody could "fix" this specific code .. By the way the aim is to fill up what I called "Ranking Table" in the sample.

Please Login or Register  to view this content.

[Izandol]

I think you have written

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

[:) Sixthsense :)]

In your second For Loop you used o Alpha instead of 0.

[ihmha]

The second for next loop needs to be;

Please Login or Register  to view this content.

(you have an 'o')

[GIS2013]

Thanks everyone. Fixed it, and now the sub returns run time error 1004, application/object defined error..

[Izandol]

You may not resize range to 0 - perhaps you intended Offset instead of Resize?

What is ranking you wish to perform - each item within same year? Perhaps you wish:

Please Login or Register  to view this content.

[GIS2013]

There are 6 cities (a-f), I try to find its relative ranking in each year (2002-2012). For instance, "city a" is ranked sixth in 2002 (since -6613 is the lowest number for 2002).

[Izandol]

Did you try code I have posted?

[GIS2013]

@Izandol - I missed it somehow. It works perfectly. Many thanks