Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell copy action pauses for 15 second for the smallest action | Excel Discussion (Misc queries) | |||
How to decide if an excel file has got VBA code in it ? | Excel Discussion (Misc queries) | |||
User to decide how often a macro runs | Excel Discussion (Misc queries) | |||
Are alien abductions real? You decide - 1 attachment | Excel Discussion (Misc queries) |