Selecting Shapes With Variable Based On Worksheet Data

[svAndiamo]

I'm working on a macro that automatically highlights a map based on the data within my worksheet. There are 35 areas on my map each with their own shape that is named for the number of the map area (100, 110, 120 to 750, 760, 770).

I need to be able to select the shape corresponding to the area so I can properly format it...

Here's my code thus far:

Please Login or Register  to view this content.

However, this part doesn't work:
"ActiveSheet.Shapes.Range(Array(Area)).Select"


So I need to know how to properly specify a variable that I can use to select the shape so that I can assign it the right color.

Any ideas?

[abousetta]

Hello and welcome to the forum,

Please take a few minutes to read the forum rules and add Code Tags around your vba code. Also where is your array I can't seem to find it in the code above.

abousetta

[svAndiamo]

Thanks for the reminder on code tags.

Since I posted, I figured out that is was an array issue, and I was able to setup an array the worked for my needs. Below is the code that solved the issue:

Please Login or Register  to view this content.