VBA Multiple IF conditions - why doesn't mine work?

[Jossilyn]

Hi there,

While looking on your site I found this post of June 2008 by Anxoperez which ended with this formula:
If ActiveCell.Value < -25 And ActiveCell.Offset(-2, 0).Value < -25 And ActiveCell.Offset(-3, 0).Value < -25 Then
Range("C4").Select
End If
End Sub

I am looking to do something similar on excel 07 as follows:
Range("O16").Select
IF ActiveCell.Offset(0,-1)Value ="1" And ActiveCell.Offset(0,-2).Value = "1" Then
ActiveCell.Value = "1"

Compile error expected: Then or GoTo At the First value (which I have highlighted in red)

Why doesn't mine work?

Also would like the If formula to repeat for range O16:O36.

Please help.

 

[Jossilyn]

aarrrggghh!
another problem

how do I get it to work automatically as opposed to going in to developer and running the code or assigning a macro?

thanks for being so patient.

 

[Blade Hunter]

What do you need to be the trigger to fire it off? Like if someone enters something in a cell or a button or a keyboard command?

 

[Jossilyn]

I guess I would like it to operate once the likelihood is rated.. ActiveCell offset (0, -1)?

 

[Blade Hunter]

OK, How do we tell that? Is it a human entry in a cell or some calculation?

We will use a worksheet_change event on the sheet level which will allow the code to fire under certain sheet level change criteria

Cheers

Dan

 

[NateO]

Hello,

Do you want VBA or a Worksheet Function alternative? Can you provide a scenario?