Private Sub Worksheet_Change(ByVal Target As Range) - 2 on one worksheet?

You still haven't described what you are trying to accomplish with your code. I can see what you code does but it doesn't mean that it is doing what you hope it is doing.

With regards to combining the Worksheet_Change, all I can say is with Worksheet_Change you specify the range or ranges that you want some code to occur. You can have as many ranges as you want.

Example:

Your two codes would be within one Worksheet_Change event. One would only trigger if the changed cell is in the named range "Cable Assy", the other would trigger if the changed cell is in B3:B2500. Now if the two ranges are the same then you are going to have to do some other defining. But since I have no idea what you are trying to do i can't help you.

Sorry I don't know enough to explain this very well but I'll try. When I isolate the 3 different macros they work fine, it is just getting them all to play together nicely. I don't understand how to combine the 2 that start with: Private Sub Worksheet_Change. If I combine a "Private Sub Worksheet_Change" and a "Private Sub Worksheet_SelectionChange then I can get two of them to work.