Public Function incr(astring As String) As String 'simple function to increment a number string incr = CStr(CLng(astring) + 1) End Function