Differences

This shows you the differences between two versions of the page.

--- microsoft_excel:macro_change_formulae_to_values [2016/07/11 11:16] – created peter
+++ microsoft_excel:macro_change_formulae_to_values [2021/08/04 14:01] (current) – removed peter
@@ Line 1: / Line 1: @@
-====== Microsoft Excel - Macro Change formulae to values ======
-<code excel>
-' Copy and paste formula ranges as values to speed up the file processing.
-.Range("K3:N" & lastrow_Sheet1) = .Range("K3:N" & lastrow_Sheet1).Value
-.Range("P3:Q" & lastrow_Sheet1) = .Range("P3:Q" & lastrow_Sheet1).Value
-.Range("AI3:AM" & lastrow_Sheet1) = .Range("AI3:AM" & lastrow_Sheet1).Value
-.Range("AR3:AT" & lastrow_Sheet1) = .Range("AR3:AT" & lastrow_Sheet1).Value
-.Range("B3:B" & lastrow_Sheet1) = .Range("B3:B" & lastrow_Sheet1).Value
-</code>