Below I have this marco the goes from row 2 to 2000(and that's okay), but I don't want to have to later in the year go and update this macor because it has exceed 2000 rows.
How can I put something like Range(Selection, Selection.End(xlDown)).Select, which goes to last record in place of 2 to 2000?
![]()
Sub col_n_check() Dim curr_Row As String For i = 2 To 2000 If ActiveSheet.Range("BV" & i).Value < 0.3 Or ActiveSheet.Range("BW" & i).Value < 0.3 Or ActiveSheet.Range("BX" & i).Value < 0.6 Then curr_Row = i & ":" & i ActiveSheet.Range(curr_Row).Interior.ColorIndex = 24 ActiveSheet.Range(curr_Row).Interior.Pattern = xlSolid End If Next i End Sub
Bookmarks