+ Reply to Thread
Results 1 to 4 of 4

Why the syntax error with the Join function?

  1. #1
    Registered User
    Join Date
    08-25-2016
    Location
    USA
    MS-Off Ver
    14.0.7172.5000 (32-bit)
    Posts
    96

    Why the syntax error with the Join function?

    What's wrong with the Join line?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Why the syntax error with the Join function?

    You can't use Join as the both the name of the procedure and as the native function.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    08-25-2016
    Location
    USA
    MS-Off Ver
    14.0.7172.5000 (32-bit)
    Posts
    96

    Re: Why the syntax error with the Join function?

    Quote Originally Posted by shg View Post
    You can't use Join as the both the name of the procedure and as the native function.
    Did not know that...

    Thanks!

  4. #4
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,420

    Re: Why the syntax error with the Join function?

    @Mark,

    'shg' answered your question, but I am curious... why are you using Split on spaces and then Join with hyphens instead of simply replacing the spaces with hyphens directly...
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Why does this give a syntax error? Coding a function
    By songhaegyo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2017, 01:42 AM
  2. [SOLVED] Syntax on line continuations around LEFT JOIN
    By ejoneslor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2016, 03:31 AM
  3. [SOLVED] Replace function in VBA macro syntax error
    By yard2010 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-24-2015, 06:18 PM
  4. Storing a Function (Getting Syntax Error)
    By kenny.fsw in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-12-2014, 05:29 PM
  5. [SOLVED] Return in function gives syntax error
    By ajaykgarg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2014, 02:05 AM
  6. getting an error- a script out of range - Join function
    By AB33 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2012, 01:29 PM
  7. Syntax Error calling StDev Function
    By ccolton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2011, 05:53 PM

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