Results 1 to 4 of 4

Thread: Can't use Right function???

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator
    2nd VP-Knowledge Base
    VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location

    Can't use Right function???

    My code use to work, but now I get a compile error with the Right function. For some reason is says "Cannot Find project or Library".

    Here's my line of code:


    SentType = Right(ActiveSheet.Shapes(Application.Caller).TextFrame.Characters.Text, 1)
    But this even happens even if I try this:

     
    Debug.Print Right("Hey" , 1)
    What gives?
    Last edited by Aussiebear; 03-14-2025 at 11:02 AM.




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

Posting Permissions

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