This should be easy... Excel cell compare

billprozac · #1 (**permalink**) 01-25-04, 02:21

I need to search a spreadsheet one column ata atime looking for specific values in each column. If the value exista at all, I need a value set to true. This is what I have...

Columns("I:I").Select
bOK = False
For bp = 1 To intRowRange
If Cells(bp).Value = "60" Then
bOK = True
Exit For
End If
Next bp

It processes, but I do not think it is searching clomn I like it is supposed to because the value 60 does exist and yet the boolean value is still returned as false. Any way I can make this work?

DavidCoutts · #2 (**permalink**) 01-26-04, 07:56

Hi Bill

I dont know if this is the best way to do this or not but this routine will work

Code:

    Lastrow = Range("A1").End(xlDown).Row
    Range("I1").Select
bok =false
    For I = 1 To Lastrow
        If ActiveCell.Formula = "60" Then
            bok = True
            Exit For
        End If
        ActiveCell.Offset(1, 0).Select
    Next I

ive tested this and it finds the value the only assumption ive made is that all your rows in column A are filled up till the last row of data i hope this is of some help to you
David

namliam · #3 (**permalink**) 01-26-04, 08:40

For one thing you should search for 60 (number) not "60" text.

Internet Services

Web Development

Digital Marketing

Consumer Tech