Dim LNewUnit As Double
Dim SNewUnit As String
LNewUnit = MetricAmount * ConversionNumber 'fill in these
For i = 1 To Len(Str(LNewUnit))
If Mid(Str(LNewUnit), i, 1) = "." Then
TempWholeNumber = CLng(Mid(Str(LNewUnit), 1, i - 1))
TempDecimaL = CDbl(Mid(Str(LNewUnit), i, Len(Str(LNewUnit)) - i +...
Sorry I didn't read all of your post.
Like MattSTech is asking, I would need to know if each string segment you need is a certain length. If it is, loop through the string segments and sort them into an array.
If you know the size of the file number and the size of the location number are...
Glowworm27, it says this thread was idle for 11 months untill you posted! Is this true? I'm just wondering because I remember reading it a while ago but no where near 11 months and people were still posting...
Anyway, thanks for digging it up. I learned so many new shortcuts!
you could also follow the code step by step with the little red circle thingys. (click to the right of a line & it will automatically debugg when it gets there)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.