Modify " Private Sub Worksheet_Change(ByVal Target As Range) "

  • Hi,


    I am stuck in the following code compile in one. If I compile then some code not working. Can anyone help to compile multiple worksheet change codes in one?

    The codes are given below.



    And Below this code



    Any help will be highly appreciated.


    Thanks in advance

  • Attach an example of your workbook.


    Also, explain what the purpose of your code is. If it's data entry then there's probably a better way.