Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    7

    Question Unanswered: Table border using scripts

    Hi,

    I want to table apply border for particular range in excel using VB script.

    Please help

  2. #2
    Join Date
    Apr 2008
    Posts
    6
    Have you tried recording a macro?

  3. #3
    Join Date
    Jun 2008
    Posts
    7
    How can i do that.

    Could u explain????

  4. #4
    Join Date
    Dec 2007
    Posts
    37

    Try this

    with ActiveCell.Borders
    .Color = RGB(0,0,0)
    .Item(xlEdgeTop).Weight = xlThick
    .Item(xlEdgeLeft).Weight = xlThick
    .Item(xlEdgeBottom).Weight = xlThick
    .Item(xlEdgeRight).Weight = xlThick
    End with




    for specific range :
    Range("a1", "b10").Borders.Weight = xlThick
    Last edited by karthic_85; 06-23-08 at 08:25.
    Meyyappan

Posting Permissions

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