PDA

View Full Version : [SOLVED] Get Weight of border of top left cell of a range



wene
03-30-2005, 02:24 AM
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)

andy_uk
03-30-2005, 02:32 AM
Try "Cells" with an "s".

Rgds,
Andy

Killian
03-30-2005, 02:35 AM
So close! just missing the "s" in "Cells"

MsgBox Selection.Cells(1, 1).Borders(xlEdgeTop).Weight

wene
03-30-2005, 03:42 AM
in the end it's always easy, believe that developer's life...

THANKS!