+ Reply to Thread
Results 1 to 4 of 4

Compile Error when calling a sub function

  1. #1
    Registered User
    Join Date
    09-23-2014
    Location
    Asia
    MS-Off Ver
    2010
    Posts
    1

    Smile Compile Error when calling a sub function

    Hi guys,

    I'm new in this forum and a noob in excel VBA. I have some issues with sub functions.
    I created a sub function that I can call inside another sub function but it returns a "Complie Error: Expected: ="
    My goal is to format cells with the number of "*"

    here is how i call the sub function:

    FormatList (2,">>Header Title<<")

    Below is my code
    Please Login or Register  to view this content.
    I hope someone can help me
    Thanks!

  2. #2
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: Compile Error when calling a sub function

    Remove the parenthesis

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    Thanks

  3. #3
    Registered User
    Join Date
    09-17-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: Compile Error when calling a sub function

    Already posted here.

    http://www.mrexcel.com/forum/excel-q...-function.html

  4. #4
    Registered User
    Join Date
    09-17-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: Compile Error when calling a sub function


+ 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 'Sub or Function is not define' error on Private Sub Getdata()
    By HafizuddinLowhim in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2014, 11:17 AM
  2. [SOLVED] Error in function Compile error: Can't find project or library
    By Motario1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-12-2013, 02:20 AM
  3. [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
  4. [SOLVED] Compile error when calling function in sub
    By g8r777 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2012, 11:26 AM
  5. Calling Sub gens Compile Error
    By grinnz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2010, 10:33 PM

Tags for this Thread

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