Using IF to decide action
 

I have two options to act in ActiveCell depending on value of cell in the
third column to the left of active cell i.e. Offset(0,-3). I have two
separate macros say Macro1 and Macro2 to call depending on if the value is
=1 or <1. I don't know the IF process. Please help.

Using IF to decide action
 

Try this

If ActiveCell.Offset(, 3).Value = 1 Then
'Macro1
ElseIf ActiveCell.Offset(, 3).Value < 1 Then
'macro2
End If

Mike

"a m spock" wrote:

I have two options to act in ActiveCell depending on value of cell in the
third column to the left of active cell i.e. Offset(0,-3). I have two
separate macros say Macro1 and Macro2 to call depending on if the value is
=1 or <1. I don't know the IF process. Please help.

Using IF to decide action
 

many thanks mike. this is what i needed. will try it out and get back if
there are any issues.

"Mike H" wrote:

Try this

If ActiveCell.Offset(, 3).Value = 1 Then
'Macro1
ElseIf ActiveCell.Offset(, 3).Value < 1 Then
'macro2
End If

Mike

"a m spock" wrote:

I have two options to act in ActiveCell depending on value of cell in the
third column to the left of active cell i.e. Offset(0,-3). I have two
separate macros say Macro1 and Macro2 to call depending on if the value is
=1 or <1. I don't know the IF process. Please help.

Using IF to decide action
 

This is what has worked.

If ActiveCell.Offset(0, -3).Value = 1 Then
Call Sale
ElseIf ActiveCell.Offset(0, -3).Value < 1 Then
Call Sale2
End If

many thanks once again.

"Mike H" wrote:

Try this

If ActiveCell.Offset(, 3).Value = 1 Then
'Macro1
ElseIf ActiveCell.Offset(, 3).Value < 1 Then
'macro2
End If

Mike

"a m spock" wrote:

I have two options to act in ActiveCell depending on value of cell in the
third column to the left of active cell i.e. Offset(0,-3). I have two
separate macros say Macro1 and Macro2 to call depending on if the value is
=1 or <1. I don't know the IF process. Please help.

Using IF to decide action
 

Glad I could help. I missed the negative 0ffset(,-3)

Mike

"a m spock" wrote:

This is what has worked.

If ActiveCell.Offset(0, -3).Value = 1 Then
Call Sale
ElseIf ActiveCell.Offset(0, -3).Value < 1 Then
Call Sale2
End If

many thanks once again.

"Mike H" wrote:

Try this

If ActiveCell.Offset(, 3).Value = 1 Then
'Macro1
ElseIf ActiveCell.Offset(, 3).Value < 1 Then
'macro2
End If

Mike

"a m spock" wrote:

I have two options to act in ActiveCell depending on value of cell in the
third column to the left of active cell i.e. Offset(0,-3). I have two
separate macros say Macro1 and Macro2 to call depending on if the value is
=1 or <1. I don't know the IF process. Please help.

Using IF to decide action
 

dear mike,
in a parallel situations what would need to be done if i need to skip all
action for offset(0,-3).value =1 and move down in the column until i find a
cell with the corresponding offset(0,-3).value <1 then call macroX

ams

"Mike H" wrote:

Glad I could help. I missed the negative 0ffset(,-3)

Mike

"a m spock" wrote:

This is what has worked.

If ActiveCell.Offset(0, -3).Value = 1 Then
Call Sale
ElseIf ActiveCell.Offset(0, -3).Value < 1 Then
Call Sale2
End If

many thanks once again.

"Mike H" wrote:

Try this

If ActiveCell.Offset(, 3).Value = 1 Then
'Macro1
ElseIf ActiveCell.Offset(, 3).Value < 1 Then
'macro2
End If

Mike

"a m spock" wrote:

I have two options to act in ActiveCell depending on value of cell in the
third column to the left of active cell i.e. Offset(0,-3). I have two
separate macros say Macro1 and Macro2 to call depending on if the value is
=1 or <1. I don't know the IF process. Please help.