+ Reply to Thread
Results 1 to 2 of 2

Compile error Expected: list separator or )

  1. #1
    Registered User
    Join Date
    05-10-2012
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    41

    Compile error Expected: list separator or )

    Hi all!

    Please help me sort the Compile error found in my code. Usually this is bad syntax or typing on my end but have been unable to find it.

    This is a selenium code designed to set a certain item in a dropdown, based on values found in a worksheet called Data:

    Please Login or Register  to view this content.
    I am receiving the error message "Compile error: Expected: List separator or )" at the worksheet's name. If I omit the worksheet reference, so it reads instead:

    Please Login or Register  to view this content.
    the compile error highlights the column name

    I've double-checked for smart quote marks and any typos but can't see any. I've used this sort of thing earlier in the code without issue, as a SendKeys command like this:

    Please Login or Register  to view this content.
    Thanks so much for your help on this!

  2. #2
    Registered User
    Join Date
    05-10-2012
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    41

    Re: Compile error Expected: list separator or )

    NM, I forgot to wrap the range

    Please Login or Register  to view this content.
    Oops!

+ 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] Expected: list separator or ) error
    By Saintor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-10-2020, 03:03 PM
  2. MsgBox compile syntax error or Expected: list separator or )
    By drummo2a in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2017, 01:24 AM
  3. Expected: list separator or ) Error Code
    By caltman242 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2015, 11:16 AM
  4. Please solve the Error : Expected List separator..
    By ANUARORA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2014, 09:51 AM
  5. [SOLVED] Function Error: Compile error: Expected: list separator or )
    By goss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-05-2014, 02:10 PM
  6. [SOLVED] Continue code on next line: Compile Error: expected list separator or )
    By ike609 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-05-2012, 08:28 AM
  7. compile error – expected : list separator or )
    By mdavid800 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2011, 04:59 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