[Solved] Difference between pre- and postfix incrementation in C (++a and a++) [duplicate]

Remember, C and C++ are somewhat expressive languages. That means most expressions return a value. If you don’t do anything with that value, it’s lost to the sands of time. The expression (a++) will return a‘s former value. As mentioned before, if its return value is not used right then and there, then it’s the … Read more

[Solved] Find maximum value in a range of strings

Use the next function, please: Function newID(sh As Worksheet) As String Dim lastR As Long, strID As String, arr As Variant, i As Long lastR = sh.Range(“A” & Rows.count).End(xlUp).Row arr = sh.Range(“A2:A” & lastR).Value strID = left(sh.Range(“A2”).Value, 4) For i = 1 To UBound(arr) arr(i, 1) = CLng(Right(arr(i, 1), 3)) Next i newID = strID … Read more