ExcelBanter - Return Cells With Border Only

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Return Cells With Border Only (https://www.excelbanter.com/excel-programming/346974-return-cells-border-only.html)

Tony

Return Cells With Border Only

Is there a way to identify a cell based its having a border?

Fredrik Wahlgren

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

All times are GMT +1. The time now is 03:10 AM.