If Then statements

[Nebular]

I have:
60
50
40
87
68
98
90
97
20
1
entered in A1:A10

This is my code:

Please Login or Register  to view this content.

it assigns all of these grades as failed...what's wrong here?

[Leith Ross]

Hello Nebular,

You are applying worksheet formula thinking to VBA code. In VBA you need to test each cell using a loop. Here is the corrected code...

Please Login or Register  to view this content.

[mesuttasar]

Hello ,another fix with "if then"

Please Login or Register  to view this content.

[Nebular]

Hello ,another fix with "if then"

Please Login or Register  to view this content.

Thank you, both work, but I like this one better.