|The Worksheet_Change code that you posted contains these lines:|
Set A = Range("G:G")
Set intr = Intersect(A, Target)
If intr Is Nothing Then Exit Sub
That means that it is checking to see if the changed cell (the Target) is in Column G.
A change in a cell caused by a calculation is not considers a "change" to the WorkSheet_Change event. Therefore, making a manual change to Column H will trigger the code, but the "Target" (which is in Column H) will not intersect with Column G, so the Exit Sub instruction will execute.
That said, you have now confused me. In your first post you said that the code was copying the formula from G to C, now you are saying that it doesn't copy G when a change is made to H.
That second part makes sense for the reason I explained. What is confusing is that I don't what you were doing previously to cause the code the copy the formulas in G to C. The only way for that to happen is to change Column G, and the only way for it to copy formulas is if you entered the formula in Column G, with that entry being "the change" i.e. the Target.
I was originally confused by what you were trying to do with the code in the first place, but I chose to simply answer your question. Now I am really curious as to what you are trying to accomplish.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03