Consulting

Results 1 to 2 of 2

Thread: Trouble Grouping Label and Shape

  1. #1
    VBAX Tutor MINCUS1308's Avatar
    Joined
    Jun 2014
    Location
    UNDER MY DESK
    Posts
    254

    Trouble Grouping Label and Shape

    Im trying to group a OLE Label and a Shape...

    'GROUP THE SHAPE AND LABEL  
    ActiveSheet.Shapes.Range(Array(ShapeName, LabelName)).Select   
    Selection.ShapeRange.Group.Select
    and im getting the error:
    "The ShapeRange object must contain at least two items."

    My normal debugging isnt fixing it, anyone have a suggestion?
    - I HAVE NO IDEA WHAT I'M DOING

  2. #2
    VBAX Tutor MINCUS1308's Avatar
    Joined
    Jun 2014
    Location
    UNDER MY DESK
    Posts
    254
    I replaced the above lines with the following and its working fine?!?

    ActiveSheet.Shapes.Range(Array(ShapeName, LabelName)).Group
    - I HAVE NO IDEA WHAT I'M DOING

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •