I'm way over my head on this project today!! My VBA knowledge is spotty.
I've disabled auto calculation on my worksheet and want to perform certain calculations only when specific data changes. My two scenarios seem to conflict.
What I want it to do, is when J5 changes, recalculate all the specified cells. OR, if any value in F4:F58 changes, recalculate just some of the cells
With the code the way I have it, when I change the value of J5, I get "run-time error 13 Type Mismatch" and it highlights [if target <> "" Then] in that second clause.
I'm assuming it's because J5 does not intersect with F4:F58 but I'm stuck on how to rewrite this to get it to work.
EDIT: Alternatively, I guess my real problem is I only want E4:E58 to recalculate when J5 changes and no other time.
Bookmarks