Results 1 to 4 of 4

Thread: Copy and paste row values in a table.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Copy and paste row values in a table.

    Having following code in .bas(macro).

    [vba]Set shpGrpTable = Slide.Shapes.AddTable(3, 6,18#,250, 681#, 600)

    Set grpTxtFrame = shpGrpTable.Table.Cell(1, 1).Shape.TextFrame
    grpTxtFrame.TextRange.Text = "GROUP"
    grpTxtFrame.TextRange.Font.Size = 14
    grpTxtFrame.TextRange.Font.Name = "Arial"
    grpTxtFrame.TextRange.Font.Color.RGB = 16777215
    grpTxtFrame.TextRange.Font.Bold = msoTrue
    grpTxtFrame.HorizontalAnchor = msoAnchorCenter
    grpTxtFrame.VerticalAnchor = 3

    Set prmTxtFrame = shpGrpTable.Table.Cell(2, 1).Shape.TextFrame
    prmTxtFrame.TextRange.Text = "COUNTRY"
    prmTxtFrame.TextRange.Font.Size = 14
    prmTxtFrame.TextRange.Font.Name = "Arial"
    prmTxtFrame.TextRange.Font.Color.RGB = 16777215
    prmTxtFrame.TextRange.Font.Bold = msoTrue
    prmTxtFrame.HorizontalAnchor = msoAnchorCenter
    prmTxtFrame.VerticalAnchor = 3[/vba]
    1. grpTxtFrame and prmTxtFrame are having the same properties. After creating grpTxtFrame, how to copy and paste grpTxtFrame into cell(2,1) and how to reassign value('COUNTRY) to cell(2,1).

    2. shpGrpTable is created in slide1 and how to copy this into slide2.

    Thanks in advance.
    Sharath.
    Last edited by Killian; 09-16-2005 at 02:31 AM. Reason: Formatting and added VBA tags

Posting Permissions

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