microsoft_excel:macros:change_range_to_values
This is an old revision of the document!
Microsoft Excel - Macros - Change range to values
' 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
microsoft_excel/macros/change_range_to_values.1628085792.txt.gz ยท Last modified: 2021/08/04 14:03 by peter