fishandtril
New Member
- Joined
- Nov 15, 2022
- Messages
- 13
- Office Version
- 365
- 2021
- Platform
- Windows
Hello
I want to run two formulas in the same procedure. Not sure how to do this.
I want to run two formulas in the same procedure. Not sure how to do this.
VBA Code:
Sub RunFormulas()
With Sheets("Canary Counterparties")
With .Range("AH7:AH" & .Range("AF" & Rows.Count).End(xlUp).Row)
.Formula = "=IF(OR(RC[-30]<TODAY(),RC[-30]>R4C3),""Exclude"",""Include"")"
.Formula = "=IFERROR(VLOOKUP((RC[-32]&"".""&RC[-21]),'Credit Limit Expiry'!C2:C5,4,0),""Error"")"
End With
End With
End Sub