|
Subject:
|
check if a cell has a bottom border
|
|
Posted By:
|
crmpicco
|
Post Date:
|
1/9/2006 5:19:14 AM
|
Is there anyway to check if a cell has a bottom border?
Picco
www.crmpicco.co.uk
|
|
Reply By:
|
mjppaba
|
Reply Date:
|
1/9/2006 5:27:16 AM
|
Hi Picco
Sub check_borders()
If ActiveCell.Borders(xlEdgeBottom).LineStyle = xlLineStyleNone Then MsgBox ("Has No Line") Else MsgBox ("Has Line")
End Sub
cheers
Matt
|
|
Reply By:
|
crmpicco
|
Reply Date:
|
1/10/2006 6:19:27 AM
|
thanks matt
www.crmpicco.co.uk
|
