Hi
I have a string variable will assign with the following value: 43,44,45,46 or 43,44,45,46,47,48.
Number of values split by the comma will varies, and it is number for sure.
I wanted to get the highest value of all. What I have tried is to split the values and make a comparison, but when I split with following mthod:
strRec = Split(rec_id, ",")
I am not able to tell the UBound or the max count of the values, cos it may contain 5, 6 or even 10 values.
I also tried UBound:
For i = 0 To UBound(rec_id)
strRec = Split(rec_id, ",")
Next
But due to the fact the "rec_id" is a string and not an array, hence UBound is not supported.
So, I would like to know how to get the max count of the variable or is there other way to get the highest values of the variable?
Thank You.
< ...
Go to the complete details ...