Dim str As String = "0101"str = str.substring(0,str.length-2) & format(val(right(str, 2))+1, "00")msgbox(str)