Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
border non-contiguous rows
I'm building a report and certain sub-total rows need top/bottom
border. The actual rows to be "bordered" will vary. I can border the subtotals as I create them, but i thought it would tidier if I kept track of the rows to be bordered and did them all at once. Is this possible: <pseudocode dim rowstoborder as string rowstoborder = "5" rowstoborder = rowstoborder & "," & "10" rowstoborder = rowstoborder & "," & "20" with rows( rowstoborder ) .Borders.LineStyle = xlNone .Borders(xlEdgeTop).LineStyle = xlContinuous .Borders(xlEdgeTop).Weight = xlThick .Borders(xlEdgeBottom).LineStyle = xlContinuous .Borders(xlEdgeBottom).Weight = xlThick end with </pseudocode |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
border non-contiguous rows
Try this idea. Modify to suit
Sub bordernoncontiguous() Range("a3,a7,a12").Borders.Weight = xlThick End Sub -- Don Guillett SalesAid Software "sugargenius" wrote in message ups.com... I'm building a report and certain sub-total rows need top/bottom border. The actual rows to be "bordered" will vary. I can border the subtotals as I create them, but i thought it would tidier if I kept track of the rows to be bordered and did them all at once. Is this possible: <pseudocode dim rowstoborder as string rowstoborder = "5" rowstoborder = rowstoborder & "," & "10" rowstoborder = rowstoborder & "," & "20" with rows( rowstoborder ) .Borders.LineStyle = xlNone .Borders(xlEdgeTop).LineStyle = xlContinuous .Borders(xlEdgeTop).Weight = xlThick .Borders(xlEdgeBottom).LineStyle = xlContinuous .Borders(xlEdgeBottom).Weight = xlThick end with </pseudocode |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
border non-contiguous rows
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
border non-contiguous rows
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to automatically delete non-contiguous rows | Excel Discussion (Misc queries) | |||
Printing non-contiguous rows at the top | Excel Worksheet Functions | |||
AVERAGEing non contiguous rows | Excel Discussion (Misc queries) | |||
Highlight non- contiguous rows | Excel Programming | |||
Highlight non- contiguous rows | Excel Programming |