Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing two dates in one column
I found this piece of code while searching for a way to underline
anytime there is a date change in column A, but it doesnt always underline correctly and if ran twice it incorrectly underlines rows. Where is the bug? I can't find it. Any help is appreciated. thanks! Dim RowNdx As Long Dim ColNum As Integer ColNum = Selection(1).Column Columns("A:A").Select Application.ScreenUpdating = False For RowNdx = Selection(Selection.Cells.Count).Row To _ Selection(1).Row + 1 Step -1 If Cells(RowNdx, ColNum).Value < Cells(RowNdx - 1, ColNum).Value Then Cells(RowNdx - 1, 1).EntireRow.Select With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With End If Next RowNdx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing dates | Excel Worksheet Functions | |||
Comparing 2 Dates | Excel Worksheet Functions | |||
Comparing Dates | Excel Discussion (Misc queries) | |||
Comparing two dates in one column | Excel Discussion (Misc queries) | |||
Comparing 3 dates | Excel Worksheet Functions |