Consulting

Results 1 to 4 of 4

Thread: Get Weight of border of top left cell of a range

  1. #1
    VBAX Newbie
    Joined
    Mar 2005
    Posts
    5
    Location

    Get Weight of border of top left cell of a range

    I expect a function call like, will return a number descriping the weight of the border:

    msgbox (Selection.Cell(1,1).Borders(xlEdgeTop).weight)
    I'm developing for Excel 2000

    (crossposted on MrExcel.com)

  2. #2
    VBAX Regular
    Joined
    Jul 2004
    Location
    Cambridge, England
    Posts
    23
    Location
    Try "Cells" with an "s".

    Rgds,
    Andy

  3. #3
    VBAX Master Killian's Avatar
    Joined
    Nov 2004
    Location
    London
    Posts
    1,132
    Location
    So close! just missing the "s" in "Cells"
    MsgBox Selection.Cells(1, 1).Borders(xlEdgeTop).Weight
    K :-)

  4. #4
    VBAX Newbie
    Joined
    Mar 2005
    Posts
    5
    Location
    in the end it's always easy, believe that developer's life...

    THANKS!

Posting Permissions

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