Worksheet change not working the way I want it to....

[jnco903]

Hi all;
Thanks in advance for your help. I have a macro set up that looks at two cells. If cell 1 has a value in it it will run MACRO(A), if cell 2 has a value in it it will run MACRO(B), please note the A/B denotes a generic name not the actual macro name. The problem I am having is for some reason I am getting the value from the Macro in cell 2 to appear in cell 1 even though I have two distinct macros. I am guessing I dont have the workbook_Change macro set up correct... below is the code

Please Login or Register  to view this content.

[Leith Ross]

Hello jnco903,

Try this revised version of your macro.

Please Login or Register  to view this content.

[jnco903]

I updated the code and its still doing the same thing...I have no idea why I cant get this thing to work...

---------- Post added at 03:13 PM ---------- Previous post was at 03:12 PM ----------

Below are my macros...maybe there is an error with them?

Please Login or Register  to view this content.

[Leith Ross]

Hello jnco903,

Are you receiving any errors messages? On what line does the code stop?

[jnco903]

I am not getting any errors and it looks like the entire code runs...

[jnco903]

K, i did some more looking into it and it looks like my macros and formulas are working okay. The issue is that Excel is changing my calculation to manual instead of keeping it automatic...is there a way to prevent this? I keep changing it back to Automatic but it then switches it back