Changing Colors of Shapes

Dear all,
I am trying to visualize profitability by city on a country map using Excel 2010.
Is it possible to create a loop to select freeforms individually and change their background colors based on certain criteria?

Please Login or Register  to view this content.

I have a shape called "freeform 1056" in a sheet but when I try to access to it using a variable I get the below:

Run Time Error 1004
The item with the specified name wasn't found.

Somehow it looks for freeform x rather than replacing the value of x in the argument and looking for freeform 1056.

Can you help?

Thanks a lot.

Seckin

Hello seckin,

You need to concatenate the number to the string. The way you have the code now, the letter "x" is added to the Shape name, not the number. Here is the corrected macro.

Please Login or Register  to view this content.