Consulting

Results 1 to 1 of 1

Thread: Remove border from pasted range from Excel

  1. #1

    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
  •