Not sure if this is what you're after or whether it's much faster. Test on a copy first.
![]()
Sub killerkoz17() Dim r As Integer Dim FormulaRange As Range Dim DestinationRange As Range Application.ScreenUpdating = False Set FormulaRange = Range("A4:YY4") For r = Range("J1") To Range("L1") Set DestinationRange = Range(Cells(r, 1), Cells(r, 674)) DestinationRange.Value = FormulaRange.Value Next r Application.ScreenUpdating = True End Sub
Bookmarks