On Jan 21, 11:39*am, "joeu2004" wrote:
"magmike" wrote:
I am trying to combine two different Worksheet_Change codes.

The simplest approach is: *rename the first Worksheet_Change procedure as
Part1 and the second as Part2. *Then enter the following Worksheet_Change
procedu

Private Sub Worksheet_Change(ByVal Target As Range)
Part1 Target
Part2 Target
End Sub

Of course, there might be some optimization that you could also do. *But the
above is the minimum effort needed.

If I catch what you are saying correctly, then I would have a total of
3 Procedures:

Private Sub Part1(ByVal Target As Excel.Range)
Private Sub Part2(ByVal Target As Range)
Private Sub Worksheet_Change(ByVal Target As Range)

And the Worksheet_Change procedure would be exactly this (without any
changes?):

Private Sub Worksheet_Change(ByVal Target As Range)
Part1 Target
Part2 Target
End Sub

This is what I have done, and neither of them work. I am sure I didn't
something wrong. Did I understand you correctly?

magmike