View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default Return Cells With Border Only


"Tony" skrev i meddelandet
ups.com...
Is there a way to identify a cell based its having a border?


Something like this?

If (Range("G15").Borders(xlEdgeRight).LineStyle = xlContinuous) Then
MsgBox "Cell G15 has a right edge border"
End If

You may have to test all four edges.

/Fredrik