I am trying to take the information in a range of cells and have each cell display as a bullet point within powerpoint. For example Cell A1 = My Sample Text 1 Cell A2 = My Sample Text 2 Cell A3 = My Sample Text 3 I want each to be bulleted in powerpoint like so. My Sample Text 1. My Sample Text 2. My Sample Text 3 The main point I want to get across is the number of cells is dynamic, sometimes I will have 3, other times I might have 5, etc.
![Bullet points copy and paste Bullet points copy and paste](/uploads/1/2/5/6/125613779/810797197.png)
Which is why I am using CurrentRegion. Here's What I have so far Range('A1').CurrentRegion.Copy For Each Cell In Range('A1').CurrentRegion.Cells ppSlide.Shapes.AddTextbox(Orientation:=msoTextOrientationHorizontalLeft:=400Top:=150Width:=350Height:=50).TextFrame.TextRange.Paste ppSlide.Shapes(1).TextFrame.TextRange.Paste.ParagraphFormat.Bullet.Type = ppBulletUnnumbered Next Cell Any thoughts on why this may not be working?
Add a bullet to a cell in a worksheet using character codes or symbols. In addition to a round bullet, you can choose to add a checkbox or other symbol. Insert bullets in a worksheet. Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More. Select a blank cell, and then on the Insert tab, click Symbol. Click Insert to place the bullet character in the cell. Click Close to close the Symbol dialog box. You will now have a bullet symbol in your cell. Highlight the symbol and press ctrl + c to copy the symbol to the clipboard. Type the text for your first bullet point and press alt + Enter at the end of the line to start a second line.