• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by go2rishu

  1. G

    Help Needed in VBA

    This is the Code I've used Dim cform, curform As String cform = "" cform = amt.NumberFormat 'amt is the source cell i = 1 curform = "" While Mid(cform, i, 1) <> "]" curform = curform & Mid(cform, i, 1) i = i + 1 Wend
  2. G

    Trying to extract Currency Symbol from a cell

    This is the Code I've used Dim cform, curform As String cform = "" cform = amt.NumberFormat 'amt is the source cell i = 1 curform = "" While Mid(cform, i, 1) <> "]" curform = curform & Mid(cform, i, 1) i = i + 1 Wend
  3. G

    Help Needed in VBA

    Hi, I have this requireemnt. I have to extract the currency Symbol, say USD or AED etc. from a cell and show it in another cell. I tried assigning the result of ActiveCell.NumberFormat in to a String and then extracting only the first part of it till "]" using a While-Loop. But it seems...
  4. G

    Trying to extract Currency Symbol from a cell

    Hi, I have this requireemnt. I have to extract the currency Symbol, say USD or AED etc. from a cell and show it in another cell. I tried assigning the result of ActiveCell.NumberFormat in to a String and then extracting only the first part of it till "]" using a While-Loop. But it seems...
See more
Back
Top