Okay,
So i have a very log IF formula
The formula works as intended.
However when i try to work it into my vba script it give me an error "expected end to IF statement" I did not have this issue before I modified the formula to include if E2=4 statements.
I have tried this as a R1C1 formula and as just formula and i get the same error either way. Did i botch something in the formula or is there an issue with the VBA. Its probably something very simple ive just been looking at this and similar code for too long right and i feel like i am just overlooking it. A second set of eyes might help.
Bookmarks