Results 1 to 10 of 10

Thread: help improve code -urgent

Threaded View

  1. Mar 8th, 2007, 01:20 PM #4
    leinad31
    leinad31 is offline
    PowerPoster
    Join Date
    Nov 2002
    Location
    Manila
    Posts
    7,629

    Re: help improve code -urgent

    Oh 174 is a label. Try replacing

    Code:
    lngIdxItm = InStrRev(strItm(0), " ")
      strItm(0) = Mid$(strItm(0), lngIdxItm, InStr(lngIdxItm, strItm(0), ";") - lngIdxItm)
    that comes before loop with
    Code:
    strItm(0) = " 174=" & Val(Mid$(strItm(0), InStr(1, strItm(0), "174=")+4))
    Last edited by leinad31; Mar 8th, 2007 at 01:23 PM.
    Roman Numerals, Number In Words,Indian Currency Format, Modified Insertion Sort, Fibonacci
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width