Macro auto updates when a cell changes

[angeleenmc]

I am having trouble trying to update certain columns with an already existing macro. I want a few columns to be updated based on several macros in place.

This is what I have so far:

Private Sub Worksheet_Changes(ByVal Target As Range)
If Target.Address = Range("B" & Rows.Count).End(xlUp).row Then
Call concatdeal
If Target.Address = Range("E" & Rows.Count).End(xlUp).row Then
Call concatdeal
If Target.Address = Range("A" & Rows.Count).End(xlUp).row Then
Call rplENTSPORTSYAKIDSNEWS
End If
End Sub

[daffodil11]

Please Login or Register  to view this content.

[angeleenmc]

Thank you! It doesn't seem to work. Let me know if I am doing something wrong. The 'Call' is equal to the Module ID correct? Want to make sure I gave you the right macro ID you need.

[daffodil11]

No, the Call is the name of the Sub.

Also, if the Sub is Private it only exists at it's module level. Instead, declare it as Public.

Inside of a Module I'm calling UNICORNS_AND_MACROS I have the following code:

Please Login or Register  to view this content.

Then in my worksheet, I have a change Event

Please Login or Register  to view this content.

[angeleenmc]

Thank you! Do you have any experience making a macro for multiple columns to equal other multiple columns (some would include calculations)?

Below is what I have so far:

Range("AG").Formula = "A"
Range("AH").Formula = "C"
Range("AI").Formula = "D"
Range("AJ").Formula = "B"
Range("AY").Formula = "E"
Range("AZ").Formula = "F"
Range("G").Formula = "F" - "E"
Range("H").Formula = If("AT"<0,"AT","")

[daffodil11]

I've written only a few hundred procedures, mostly I'm a tinkerer. Would you be running this for multiple rows as well?

For example let's apply some changes to all the columns from row 5 to row 10:

Please Login or Register  to view this content.

This would run through 5 to 10, substituting i for a number each time.

[angeleenmc]

Yeah and the range starts at row 8 for example. formula ends when the data ends