Select group of Objects - Macro

[Zanatos]

I have a big group of objects on a picture that I need to select, the only info I have is that it is Group678. The picture is being moved constantly and I need to be able to select it from anywhere on the page with this macro, so I cannot just produce a range where it will always be found. I have a command button that will run this if possible. Does anyone know the command to do this?

Thanks!

 

[pgc01]

Hi Zanatos

You don't have to select the objects to move them. Assuming they are grouped and the name of the group is Group678 (bad choice of name, it seems), this code moves the group to the top left of the worksheet.

    With ActiveSheet.Shapes("Group678")
        .Left = 0
        .Top = 0
    End With