Find the maximum or large of a string ID

[kelly mort]

Say I have

CPI_101
CPI_109

And more as IDs in my database . Can I use vba to find the largest number part?

It's looking trick for me.

Thanks

 

[kelly mort]

One last request :

How do I get only the digits after the "_"

That's after getting that largest ID into that cell, how do I get the digits after the underscore?

With static ones I can do with the "right function".

But now I am stacked

 

[Fluff]

If you're referring to JoeMo' code then remove the part in red

If MaxVal > 0 Then
    LargestPartID = [COLOR=#ff0000]Prefix &[/COLOR] MaxVal
Else
    LargestPartID = CVErr(xlErrValue)
End If

 

[kelly mort]

If you're referring to JoeMo' code then remove the part in red

If MaxVal > 0 Then
    LargestPartID = [COLOR=#ff0000]Prefix &[/COLOR] MaxVal
Else
    LargestPartID = CVErr(xlErrValue)
End If

Brilliant! !!

Working great

 

[Fluff]

You're welcome