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