-
Remove border from pasted range from Excel
Via Excel, I copy ranges and paste them onto a powerpoint presentation. I either paste the ranges where link:= true or link:=False. When I print the document, the ranges where link:=False show up with borders around them. In powerpoint, I can highlight the range, right-click and select "Borders and Fill", select the "Fill" tab, and uncheck the "Fill color" box to remove the borders. However, when I try to record a macro while doing this, no recorded code results. Is there a way to do this in the code?
Thank you!
[vba]RangeName = "ODateForm"
SheetName = "Control"
Worksheets(SheetName).Range(RangeName).Copy
ppSlide.Shapes.PasteSpecial(ppPasteHTML, link:=True).Select[/vba]
[vba]SheetName = "Profile"
RangeName = "ProfHeader"
Worksheets(SheetName).Range(RangeName).Copy
ppSlide.Shapes.PasteSpecial(ppPasteHTML, link:=False).Select[/vba]
Last edited by mferrisi; 07-10-2008 at 06:42 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules