User Stamp when Modifying a Cell

I am trying to make it so if any cell is modified in ranges D12:D20, D22:D25, D27:D37 or D39:D45, a user stamp appears in the column beside it, I have the following code so far, but it will only work for the first set of ranges, I am pretty sure its because I have set to " Is Nothing Then Exit Sub" after the first "If" statement, but I dont know what the correct way is to make this work, it should be pretty simple. Kinda new at this Excel VBA thing so bear with me. Thank you!

Please Login or Register  to view this content.

Solved, Thank you Paul!

Originally Posted by Paul

Please Login or Register  to view this content.

Hi Cg, you're probably better off using:

Please Login or Register  to view this content.

On another note, "Application.UserName" can be blank or incorrect as it is easily modifiable in the Excel Options window. You may want to try Environ("Username") instead, which will return the Windows login of the currently logged in user.