+ Reply to Thread
Results 1 to 16 of 16

vba not accepting the symbol <

  1. #1
    Registered User
    Join Date
    06-18-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    47

    vba not accepting the symbol <

    why is vba when i type my code does it return < as a unexpected expression??????????

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: vba not accepting the symbol <

    Do you mean you get an error as soon as you type '<' or do you mean something else?
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    06-18-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: vba not accepting the symbol <

    i type my code and it highlights "<" and returns it as an error?

  4. #4
    Registered User
    Join Date
    06-18-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: vba not accepting the symbol <

    go on then?

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: vba not accepting the symbol <

    Well lets see the code........you are trying to write.

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: vba not accepting the symbol <

    Highlights it as you type, or afterwards? If afterwards, what is the actual code?

  7. #7
    Registered User
    Join Date
    06-18-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: vba not accepting the symbol <

    Please Login or Register  to view this content.

  8. #8
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: vba not accepting the symbol <

    You need some spaces.

    Please Login or Register  to view this content.

  9. #9
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: vba not accepting the symbol <

    Is your space bar broken?

  10. #10
    Registered User
    Join Date
    06-18-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: vba not accepting the symbol <

    shouldnt it automatically space them???????????

  11. #11
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: vba not accepting the symbol <

    No - it will attempt to put spaces anywhere obvious (such as if you typed <7, it would convert to < 7) but it would not be practical (or helpful) for it to try and parse out that ifcells should be If Cells and so on.

  12. #12
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: vba not accepting the symbol <

    Perhaps you should buy a new keyboard as you don't appear to be capable of typing a coherent sentence.

  13. #13
    Registered User
    Join Date
    06-18-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: vba not accepting the symbol <

    thanks very much working nicely now

  14. #14
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: vba not accepting the symbol <

    Nope, it may autospace
    Please Login or Register  to view this content.
    but it will not autospace two words put together

  15. #15
    Registered User
    Join Date
    06-18-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: vba not accepting the symbol <

    right dave what is your question?

  16. #16
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: vba not accepting the symbol <

    Your not ready...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1