Excel Programming

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

Edit this Article
Was this page helpful?
Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful.. Leave ErnesTech Feedback.Feedback
If you log in, you will be notified when someone leaves a comment.

Other users would like to know if this solution helped you.

Your Session is Ending
Login to Continue

© 2021 - ErnesTech - Privacy