Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: seting the value of a cell to 0999

    I have some code that uses instr & len to extract a code from a cells value then :

    Selection.Value = _
    CStr(Right(Selection.Value, L - spc ))
    Selection.Offset(1, 0).Select
    this should leave the cell with 0999 but instead it ends up 999

    how can i change that?

  2. #2
    Join Date
    Oct 2003
    Posts
    311
    figured it out :


    I have some code that uses instr & len to extract a code from a cells value then :

    Selection.Value = "'" & _
    CStr(Right(Selection.Value, L - spc ))

Posting Permissions

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