Keep formula last record, for 2nd xlup clear formula in excel

[Iarianna81]

Hi guys... Im newbie in here... I need help regarding below issue...
I have set formula in specific cell excel... Update data using userform... But i need remove value formula for 2nd last row xlup for avoid slow data.... Only keep last row formula for next record...any advice.......thanks for help

 

[D3allamerican07]

Iarianna81,

Enter this portion of the code at the bottom of your code. It finds the last row and then copies and pastes values to the row above it.

    lastRow = Range("A" & Rows.Count).End(xlUp).Row
    
    Range("A" & lastRow - 1).Copy
    Range("A" & lastRow - 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

Let me know if you have any issues.

Bill

 

[Iarianna81]

i already try...but cant run
Sub ClearFormula()
Dim lRow As Long 'tambah
lastrow = Range("A" & Rows.Count).End(xlUp).Row

Range("A" & lastrow - 1).Copy
Range("A" & lastrow - 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub