Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    70

    Unanswered: Deleting part of a border in VBA

    Hi,

    I have the following code that adds a border to the top of a cell:

    Code:
    rngCell.Offset(0, -1).Borders.Item(xlEdgeTop).Weight = xlThick
    This work fine but how do I do the complete opposite? I cant use code that deletes all borders as I may have borders on the bottom that I dont want deleting!

    Any help would be great

    Thanks,

    OB1

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    You could try this
    Code:
    rngCell.Offset(0, -1).Borders.Item(xlEdgeTop).LineStyle = xlNone
    MTB

  3. #3
    Join Date
    Dec 2007
    Posts
    70
    Thanks Mike worked a treat

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •