Selecting Multiple Shapes

[ExcelWizards]

Why won't this work?

ActiveSheet.Shapes.Range("$c$3:$c$33").Select

I do not want to list them all separately in an array, there are far too many.

[Richard Buttrey]

Hi,

Does
ActiveSheet.Shapes.SelectAll
help?

[ExcelWizards]

I wish, I need to select only certain columns because I have different types of DropDowns with different choices in them, and I only want to additems by columns

[Richard Buttrey]

Hi,

Then how about

Please Login or Register  to view this content.

[ExcelWizards]

A few quick modifications, and it's working like a charm.

Thank You.