Hi,
I am getting error invalid or unqualified reference. If I copy-paste special-value then the superscript macro in the sheet module didn’t work. So I want to change the formula into value but I am getting error.
The code is:
Sub Total()
Range("i8").FormulaR1C1 = _
"=IF(RC[-2]="""","""",IF(RC[-1]=0,RC[-2],CONCATENATE(RC[-2],""+"",RC[-1])))"
    Range("i8").Copy
                    Range("i9:i100").Select
    ActiveSheet.Paste
                'Range("i8:i100").Copy
        'Range("i8:i100").PasteSpecial Paste:=xlPasteValues
Formula = .Value
        MsgBox "Done", 64
End Sub
Any help will be appreciated.

Thanking you.