On Feb 14, 11:17 am, Joel wrote:
One suggestion is not to use hard codes for Text cells
Declaring cell as Const. Then I simply change the const statement rather
than changing a lot of code.



" wrote:
I have a macro that changes a cell value, for example it changes the
value of cell "A1", I have another macro that I have set to run in the
worksheet_change event when "A1" is changed. My problem is when I run
the first macro and it changes the value in "A1" in doesn't run the
second macro. Is there something I need to do so it will recognize the
change in "A1" and consider it as the target so my second macro will
run?

Any help would be greatly appreciated.- Hide quoted text -

- Show quoted text -

If I remember, you can't declare a cell, since it's not an object in
the Object Model. You have to declare the range, in this case, a
single cell.