Results 1 to 14 of 14

Thread: Solved: Easy format Question

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    May 2007
    Posts
    81
    Location
    Ahhhh......Mr.X

    [VBA]
    T1.AddItem Format(Value, "0%")
    [/VBA]
    Runtime Error 70:

    Permission Denied
    Kindest Regards,
    Mike

    I love to Excel

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Quote Originally Posted by tccmdr
    Ahhhh......Mr.X

    [vba]
    T1.AddItem Format(Value, "0%&quot
    [/vba] Runtime Error 70:

    Permission Denied
    Value was just used to show you where to post your value. I had no idea whether it was a variable, a range or what. You need to plugin the real value.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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