| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Cells With Border Only
Is there a way to identify a cell based its having a border?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Border Cells | Excel Worksheet Functions | |||
| I want to select only cells with a border | Excel Discussion (Misc queries) | |||
| Excel Border Cells | Excel Discussion (Misc queries) | |||
| Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
| cells not printing within border | Excel Worksheet Functions | |||
Linear Mode
