Thanks for the feedback.
I noticed that it was on manual, but couldn't figure out why.
Now that you mention it, I can see it in the code. I am
assuming I can simply change the from
Application.Calculation = xlCalculationManual
Application.Calculation = xlCalculationAutomatic
I tried changing it in the excel calculations options, but it
would always default back to manual.
Also, you can ignore the macro4. I could not figure out how to
run the change macro when a cell was changed, so I recorded
macro while hitting F9 to calculate.
I will try the range you noted.
Thanks again for the help