BobSmith2112
New Member
- Joined
- Mar 8, 2018
- Messages
- 6
I am trying to add what I thought would be an easy addition to my code.
I have two macros that calculate using different formulas.
I want to automatically call the right macro if the cell 2 rows above the active cell is "W"
Although the value is "W" the macro jumps straight to the else statement and calls the wrong macro.
I have two macros that calculate using different formulas.
I want to automatically call the right macro if the cell 2 rows above the active cell is "W"
Although the value is "W" the macro jumps straight to the else statement and calls the wrong macro.
Code:
Sub Wednesday()
Range("graynext").Select
If ActiveCell.Offset(-2, 0) = "W" Then
Call PasteandcalcSat
Else
Call PasteAndDown
End If
End Sub
[\code]