MS_Xsmell
Board Regular
- Joined
- Jan 27, 2007
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
I have always assumed using rg.Value2 = rg.Value2 was significantly faster than rg.copy: rg.PasteSpecial xlPasteValues. However, I'm questioning this assumption as I test a large block of formulas on a worksheet.
Why I am seeing better results using copy/paste values (6 seconds to run vs 4 seconds)? Any better approaches to hard code large blocks of active formulas than these?
Dim rg as Range
set rg = Range("Y18:EO8000") 'giant range of a live formulas I want to hard-code
rg.Copy: rg.PasteSpecial xlPasteValues
Dim rg as Range
set rg = Range("Y18:EO8000") 'giant range of a live formulas I want to hard-code
rg.Value2 = rg.Value2
Why I am seeing better results using copy/paste values (6 seconds to run vs 4 seconds)? Any better approaches to hard code large blocks of active formulas than these?
Dim rg as Range
set rg = Range("Y18:EO8000") 'giant range of a live formulas I want to hard-code
rg.Copy: rg.PasteSpecial xlPasteValues
Dim rg as Range
set rg = Range("Y18:EO8000") 'giant range of a live formulas I want to hard-code
rg.Value2 = rg.Value2