Ph8l Posted October 20, 2004 Share Posted October 20, 2004 I need abit of help doing this, i've never really used excel and was wondering how to check weither or not a value say in coloum A1 exists anywhere in coloum A2. Link to comment Share on other sites More sharing options...
0 Ph8l Posted October 20, 2004 Author Share Posted October 20, 2004 NVM worked it out... about 4hrs ago, forgot to say i did it. For those who want to know... Sub checker() Dim iTotal As Integer Dim xTotal As Integer iTotal = InputBox("First Columns Length") xTotal = InputBox("Second Columns Length") For i = 0 To iTotal - 1 Range("A1").Select ActiveCell.Offset(i, 0).Select For x = 0 To xTotal If ActiveCell.Value = ActiveCell.Offset(x - i, 1).Value Then ActiveCell.Offset(0, 2).Value = ActiveCell.Value End If Next x Next i End Sub Link to comment Share on other sites More sharing options...
Question
Ph8l
I need abit of help doing this, i've never really used excel and was wondering how to check weither or not a value say in coloum A1 exists anywhere in coloum A2.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts