VBA – Excel Change Formulas to Values

Changing formulas to values is something really easy in MS Excel – what the majority of people (including me) would do the following – simply record a macro, where you select all cells and paste them as values. The result would look like this:

Actually, it is not that bad, as far as it functions. Anyway, there is a better and probably faster way to do the same operation:

With this macro we do not use copy and paste, but a better method simply assigning the value to the cell. I prefer it, because it is a little faster and when the file size is bigger than a few MB, then the speed is obvious.

Enjoy!

About

VBA Developer

Tagged with: , ,