Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
I am using this to convert formulas to values, however it takes forever as I think it is looking at all data in the current region. I need it to only check one column and in a sheet which may not be the active sheet.
I need it to run much faster on large amounts of data, anything after 300 to 400 forumals and it takes a long time.
Sheet "PastedSheet"
Column C
I need it to run much faster on large amounts of data, anything after 300 to 400 forumals and it takes a long time.
Sheet "PastedSheet"
Column C
VBA Code:
'''CONVERT FORMULAS TO VALUES
Dim wb As Workbook: Set wb = ThisWorkbook
Dim ws As Worksheet
Dim Rng As Range
Set ws = wb.Sheets("PasteSheet")
For Each Rng In ws.UsedRange
If Rng.HasFormula Then
Rng.Formula = Rng.Value
End If
Next Rng
End If