If you program in Excel using VBA, I know that VB in Excel is no longer supported by Microsoft. They stopped supporting it but some companies use it to do basic calculations in excel. It is imperative that you at least acknowledge it, just know the basics, it's awesome.
So, long story short. When you are trying to copy and paste using the macro (automated function), it is common that you will run into a problem where you want to copy and paste values, not references. Problem Break Down: It is frustrating to past calculated fields that does not show values but only this symbals #VALUES!
but the solution is simple. Just include this code when pasting xlPasteValues Read more here