How to Combine two Private Sub Worksheet_Change ?

Hello All

Could you please help me
How to Combine the below two Private Sub Worksheet_Change (in the same sheet).

Please Login or Register  to view this content.

And

Please Login or Register  to view this content.

because it did not works with me in such situation

appreciated

I think you'll need to explain more about what you're wanting to do. The first macro essentially says "If the change is in Column H, do something, otherwise quit". The second says "if the change isn't in column N, exit the sub. If it IS in column N, do something". So you have two checks, one for Column H, one for Column N. Which should come first, and how should it work? For instance, I think one of these two things is what you want to do, but I'm not sure which:
1) if the change is in column H, do something, but if it isn't in column H, then check to see if it's in Column N. If it is, do something, otherwise quit.
2) if the change is in column N, do something, but if it isn't in column N, then check to see if it's in Column H. If it is, do something, otherwise quit.

dear jomili

the two codes is not connected to each other, every code is working alone.

when putting one code in the sheet; everything is working but when I put the two code; it deactivated both codes

so I need to combine the two codes in proper way
no matter what is first because they work automatically and separately

Dear Winon


That is what exactly what I need

It works


Thank you so mush

Marked as solved

Winon

wish you all the best in your life