aberenguel
Board Regular
- Joined
- Aug 10, 2006
- Messages
- 83
Here's my code
Sub balance_transfer()
' balance_transfer Macro
' Written 09/13/2006 by Anthony Berenguel
'
'
Sheets("OUTPUT TRANSFER").Select
If Range("az235").Select = "FALSE" Then
Call rebalance_1
ElseIf Range("AZ235").Select = "FALSE" Then
Call rebalance_2
ElseIf Range("AZ235").Select = "FALSE" Then
Call rebalance_3
End If
End Sub
I have typed FALSE in cell AZ235 of the output transfer sheet. Therefore excel should call the rebalance_1() macro. But it doesn't. When i step through this code it never calls any of the rebalance macros even though AZ235 equals FALSE.
Please help,
Anthony Berenguel
Sub balance_transfer()
' balance_transfer Macro
' Written 09/13/2006 by Anthony Berenguel
'
'
Sheets("OUTPUT TRANSFER").Select
If Range("az235").Select = "FALSE" Then
Call rebalance_1
ElseIf Range("AZ235").Select = "FALSE" Then
Call rebalance_2
ElseIf Range("AZ235").Select = "FALSE" Then
Call rebalance_3
End If
End Sub
I have typed FALSE in cell AZ235 of the output transfer sheet. Therefore excel should call the rebalance_1() macro. But it doesn't. When i step through this code it never calls any of the rebalance macros even though AZ235 equals FALSE.
Please help,
Anthony Berenguel