Consulting

Results 1 to 3 of 3

Thread: Solved: Formula question

  1. #1
    VBAX Tutor
    Joined
    Feb 2006
    Posts
    295
    Location

    Solved: Formula question

    Hi,


    How can I write to following to read only 2 characters from the right?

    FF1 = Range("G4")

    i know there's a formula Right(G4,2) but how can i write this in code?


    thanks
    zach

  2. #2
    VBAX Contributor moa's Avatar
    Joined
    Nov 2006
    Posts
    177
    Location
    FF1 = right(Range("G4"),2)
    Glen

  3. #3
    VBAX Tutor
    Joined
    Feb 2006
    Posts
    295
    Location
    hi Glen,

    Thanks! it was the parentheses that threw me of


    zach

Posting Permissions

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