icu222much
Technical User
I have a table in PowerPoint with several rows and columns of data. I would like to resize selected columns so the width of the column does not exceed the width of the longest data - in otherwords make the column width the perfect fit. I am wondering how I would go abouts in doing this?
Below are the two approaches I have tried but they did not work. When I went to run my macro, there were no errors, but the column widths did not change.
Below are the two approaches I have tried but they did not work. When I went to run my macro, there were no errors, but the column widths did not change.
Code:
mySlide.Shapes(mySlide.Shapes.Count).Table.Columns(1).Width = ppAutoSizeShapeToFitText
Code:
mySlide.Shapes(mySlide.Shapes.Count).Table.Cell(targetRow, targetColumn).Shape.TextFrame.AutoSize = ppAutoSizeShapeToFitText