Hi,
I am trying to obtain a value only by running the following code in VBA. Its taking a long time to run. Is there a code I can use to speed this process up?
>>> use code - tags <<<
I am trying to obtain a value only by running the following code in VBA. Its taking a long time to run. Is there a code I can use to speed this process up?
>>> use code - tags <<<
Code:
Sub SMUHrs()
Dim last_row As Long
last_row = Cells(Rows.Count, 3).End(xlUp).Row
Range("B2").FormulaR1C1 = "=SUMIFS(SMUHrs!R6,SMUHrs!R1,digrates!RC[-1])"
Range("B2").AutoFill Destination:=Range("B2:B" & last_row)
Dim rngCell As Range
For Each rngCell In Selection
If rngCell.HasFormula Then
rngCell.Value = rngCell.Value
End If
Next
End Sub
Last edited by a moderator: