View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.