mohon pencerahannya mengenai rumus VBA berikut
Sub newrecord() ' Customer_number Macro ' newe number for new record Sheets("COBA").Select Range("c23").Select ActiveCell.FormulaR1C1 = "=MAX(COUNTIF{'DATABASE'!c[-2]})+1" Range("c2").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveSheet.Paste Application.CutCopyMode = False Sheets("INPUT").Select Sheets("COBA").Select Range("c2").Select Selection.Copy Sheets("INPUT").Select Range("A2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub
masalahnya rumus ini ==> ActiveCell.FormulaR1C1 = "=MAX(COUNTIF{'DATABASE'!c[-2]})+1" tidak bisa bekerja.
rumus asal seperti berikut =MAX(COUNTIF(DATABASE!B:B;C2))+1
terimakasih bantuannya