How do I get a particular macro (or macros) to automatically run when any
cell in a particular range of cells change? I don't have much experience in
VBA.

Hi
see:
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Brian" schrieb im Newsbeitrag
...
How do I get a particular macro (or macros) to automatically run when
any
cell in a particular range of cells change? I don't have much
experience in
VBA.

Brian

Use a private sub on the sheet in question.

Private Sub Worksheet_Change()
code to check what cells were changed and call appropriate macro
end sub

"Brian" wrote:

How do I get a particular macro (or macros) to automatically run when any
cell in a particular range of cells change? I don't have much experience in
VBA.

Thanks,

I think this is a good start in the right direction!

Brian



"Damo" wrote:

Brian

Use a private sub on the sheet in question.

Private Sub Worksheet_Change()
code to check what cells were changed and call appropriate macro
end sub

"Brian" wrote:

How do I get a particular macro (or macros) to automatically run when any
cell in a particular range of cells change? I don't have much experience in
VBA.