Hello,
I have a problem with one of the loop I'm trying to do and I think it's in the formula but could somoene help me ?
Also I saw that some macro run faster without Loop, is there a way to convert my code without loop ?
Here the code thanks !
I have a problem with one of the loop I'm trying to do and I think it's in the formula but could somoene help me ?
Also I saw that some macro run faster without Loop, is there a way to convert my code without loop ?
Here the code thanks !
VBA Code:
'Put the total cost plus fee at the end of each code
Dim A As Long
Dim B As Integer
A = ActiveCell.Offset(0, -2)
B = Sheets("Notes").Range("B1")
Range("K13").Select
Do Until ActiveCell.Offset(0, -8) = "Total"
If ActiveCell.Offset(1, -2) = "" Then
ActiveCell = A * (1 + B)
Else
ActiveCell.Offset(1, 0).Select
End If
Loop
End Sub