View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephen Bullen[_4_] Stephen Bullen[_4_] is offline
external usenet poster
 
Posts: 205
Default Checking for the border style of a range

Hi Peter,

if activesheet.range("IssueRed").BorderAround Weight:=xlThick then

but this doesn't seem to be quite right.

Can anyone out there enlighten me as to the syntax I should be using?


You can't check for the outline as a whole, only individual borders:

If ActiveSheet.Range("IssueRed").Borders(xlTop).Weigh t = xlThick Then

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev