Microsoft® Excel® based database addin

 

+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    bourgui Guest

    Default Merged cells in Powerpoint

    Hi all,

    I'm looking for a way to determine which cells are merged in
    Powerpoint tables. I'm a little dumbfounded that there is no "merged"
    property on the Cell object.

    So far I've had to resort to selecting a first cell, then checking of
    other potential cells are also selected, but it is ugly and time
    consuming (not to mention you can't do this silently).

    Am I missing something obvious here?

    Thanks!

  2. #2
    Chirag Guest

    Default Re: Merged cells in Powerpoint

    Each cell in a Table refers to the Shape object. This object is the same for
    merged cells and is different for separate cells. So, if a 5x5 table is
    selected and cell (3,3) and (3,4) are merged, the following returns True:

    With ActiveWindow.Selection.ShapeRange(1).Table
    MsgBox .Cell(3, 4).Shape Is .Cell(3, 3).Shape
    End With

    Once you have a reference to the table shape, you don't have to select the
    shape or any cell to know whether the cells have been merged.

    - Chirag

    PowerShow - View multiple PowerPoint slide shows simultaneously
    http://officeone.mvps.org/powershow/powershow.html

    "bourgui" <bourgui@gmail.com> wrote in message
    news:036fea18-9fb6-4b88-8bb6-450813e43c2b@f10g2000vbf.googlegroups.com...
    > Hi all,
    >
    > I'm looking for a way to determine which cells are merged in
    > Powerpoint tables. I'm a little dumbfounded that there is no "merged"
    > property on the Cell object.
    >
    > So far I've had to resort to selecting a first cell, then checking of
    > other potential cells are also selected, but it is ugly and time
    > consuming (not to mention you can't do this silently).
    >
    > Am I missing something obvious here?
    >
    > Thanks!



  3. #3
    Bourgui Guest

    Default Re: Merged cells in Powerpoint

    Thanks Chirag,

    That was so simple, yet I never thought of it. I only tried testing the
    names of the shapes, which is not always available.

    Thanks again!

Bookmarks

Posting Permissions

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