Log in

View Full Version : Remove border from pasted range from Excel



mferrisi
07-09-2008, 04:32 PM
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!


RangeName = "ODateForm"
SheetName = "Control"
Worksheets(SheetName).Range(RangeName).Copy
ppSlide.Shapes.PasteSpecial(ppPasteHTML, link:=True).Select


SheetName = "Profile"
RangeName = "ProfHeader"
Worksheets(SheetName).Range(RangeName).Copy
ppSlide.Shapes.PasteSpecial(ppPasteHTML, link:=False).Select