microsoft_excel:macro_change_formulae_to_values
This is an old revision of the document!
Microsoft Excel - Macro Change formulae 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/macro_change_formulae_to_values.1594805433.txt.gz ยท Last modified: 2020/07/15 09:30 by 127.0.0.1