+ Reply to Thread
Results 1 to 4 of 4

Compile error: Expected variable or procedure, not module

  1. #1
    Forum Contributor
    Join Date
    10-29-2009
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    125

    Compile error: Expected variable or procedure, not module

    Hi

    I'm getting Compile error: Expected variable or procedure, not module from the following 2 x codes

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    What is causing the error?
    and
    How do I solve this?

    Many thanks!

  2. #2
    Forum Contributor
    Join Date
    10-29-2009
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    125

    Re: Compile error: Expected variable or procedure, not module

    I named the module and the procedure the same name

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Compile error: Expected variable or procedure, not module

    have you renamed your modules with the same name as your procedures? if you have, change the name of one or the other
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Registered User
    Join Date
    09-27-2015
    Location
    Tardis
    MS-Off Ver
    2014
    Posts
    1

    Lightbulb Re: Compile error: Expected variable or procedure, not module

    Quote Originally Posted by JosephP View Post
    have you renamed your modules with the same name as your procedures? if you have, change the name of one or the other
    WOW! I have been searching for over an hour. Thanks! this worked great. It would not let me change the name until I realized I was still running it.

+ 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] Compile Error in Hidden Module and Compile Error: Can't find project or library
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2013, 07:03 PM
  2. HELP Getting a Compile Error: Expected End With
    By turtles62 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2012, 11:27 PM
  3. [SOLVED] Problem with "Compile error: Expected Fuction or variable"
    By perducci in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2012, 11:59 AM
  4. Mac issue (please help) "Compile error: Expected Function or variable"
    By m1notaur in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-22-2011, 06:00 PM
  5. Compile Error:- expected function or variable problem
    By skin.uk1 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-08-2011, 02:56 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