Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please help to debug following code which was collected and restructured
several codes from the discussion groups. I intended to add a thick black bottom border to upper row if two rows contain different data, and then add a blank row in between, now correct number of rows has formatted with a thick black bottom border but all placed start from the last row up. Expected result AAAA AAAA AAAA 'thick bottom border 'Empty row in between BBBB BBBB 'thick bottom border 'Empty row in between CCCC 'thick bottom border Dim LastRow As Long Dim lngRow As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row Range("A1:X" & LastRow).Select For lngRow = Cells(Rows.Count, 2).End(xlUp).Row To 2 Step -1 If Range("B" & lngRow) < Range("B" & lngRow - 1) Then Selection.Borders(xlEdgeTop).LineStyle = xlDot Selection.Borders(xlEdgeTop).Weight = xlThin Selection.Borders(xlEdgeTop).ColorIndex = 15 Selection.Borders(xlEdgeBottom).LineStyle = xlContinuous Selection.Borders(xlEdgeBottom).Weight = xlThick Selection.Borders(xlEdgeBottom).ColorIndex = 1 Selection.Borders(xlEdgeRight).LineStyle = xlDot Selection.Borders(xlEdgeRight).Weight = xlThin Selection.Borders(xlEdgeRight).ColorIndex = 15 Selection.Borders(xlInsideVertical).LineStyle = xlDot Selection.Borders(xlInsideVertical).Weight = xlThin Selection.Borders(xlInsideVertical).ColorIndex = 15 Selection.Borders(xlInsideHorizontal).LineStyle = xlDot Selection.Borders(xlInsideHorizontal).Weight = xlThin Selection.Borders(xlInsideHorizontal).ColorIndex = 15 Rows(lngRow).EntireRow.Insert Else Selection.Borders.LineStyle = xlDot Selection.Borders.Weight = xlThin Selection.Borders.ColorIndex = 15 End If Rgds |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Easiest way to Debug Code | Excel Programming | |||
debug code | Excel Discussion (Misc queries) | |||
Please help debug this code! | Excel Programming | |||
Debug Error in Code | Excel Discussion (Misc queries) | |||
Need help with code debug please | Excel Programming |