Thread
:
return non matches
View Single Post
#
2
Posted to microsoft.public.excel.programming
excelent
external usenet poster
Posts: 695
return non matches
well i would do it this way:
Sub NewMatch()
Dim i As Long
For i = 1 To 5
If Sheets(1).Cells(i, 1) < Sheets(2).Cells(i, 1) Then
Sheets(1).Cells(i, 2) = Sheets(2).Cells(i, 1)
End If
Next
End Sub
Reply With Quote
excelent
View Public Profile
Find all posts by excelent