Results 1 to 13 of 13

Thread: ***Resolved***Format function causing probs in excel 97 VBA

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member beasty1711's Avatar
    Join Date
    Mar 2001
    Posts
    418

    ***Resolved***Format function causing probs in excel 97 VBA

    im getting

    Compile Error:
    Can't Find Project Or Library

    from this line of code
    VB Code:
    1. MMO_FP.tv_ratings.Value = Format(Sheet6.Cells("c3").Value, 0)

    all i'm trying to do is take the decimal places off the number in cell C3

    any ideas?
    Last edited by beasty1711; Jan 23rd, 2003 at 10:29 AM.
    "...They even have the internet on computers..." :- Homer Simpson

    "Second Place is First Looser" :- No Fear

Posting Permissions

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



Click Here to Expand Forum to Full Width