When I then run the basic export to table code above, it only grabs the first one and leaves out all subsequent post-its.

This causes every generation of a post-it to create a shape with the exact same named pieces ('Background', 'Text', 'Title').

ActiveSheet.PasteĪ(Array('BluePostIt')).Visible = FalseĪpplication.ScreenUpdating = True 'Application.ScreenUpdating = FalseĪ(Array('BluePostIt')).Visible = True The VBA to create a new one based on that color (as I have a button for 9 different post-it color options) is: I currently have it set-up where the shape is already built and named according to the style above, with the original 'template' hidden. The reason they all end up with the exact same name is the VBA used to generate the post-its. Sorry for the confusion - the shape is a 'post-it' that contains a background square ('Background'), title bar ('Title') and text box ('Text'). What is the name of the shapes? You said the name comprises three parts but the examples you gave only have one part.

Visual basic for excel for loop