Differences

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

--- microsoft_excel:macros:change_range_to_values [2021/08/04 14:03] – created peter
+++ microsoft_excel:macros:change_range_to_values [2021/08/04 14:58] (current) – removed peter
@@ Line 1: / Line 1: @@
-====== Microsoft Excel - Macros - Change range 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>