User Tools

Site Tools


microsoft_excel:macro_change_formulae_to_values

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
microsoft_excel:macro_change_formulae_to_values [2020/07/15 09:30] – external edit 127.0.0.1microsoft_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> 
  
microsoft_excel/macro_change_formulae_to_values.1594805433.txt.gz · Last modified: 2020/07/15 09:30 by 127.0.0.1

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki