my below code gives me output as ES1 and the counter is not working as output ES1, ES2, ES3 and so on. I am not sure what is wrong.
Private Sub CommandButton1_Click()
Dim i As String, e As String
i = 1
e = "ES"
Set Rng = Sheets("sheet1").Cells(Rows.Count, 3).End(xlUp).Offset(1, 0)