+ Reply to Thread
Results 1 to 4 of 4

Compile Error Expected: End of statement

  1. #1
    Registered User
    Join Date
    05-03-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Cool Compile Error Expected: End of statement

    OK so here is what I am trying to do,

    I have the below macro or VBA what ever you call it so that users no where to input text and data in a form and then when they click print it will hide the background color this is the code I am using but it keeps telling me
    Compile Error:
    Expected: End of statement.

    What am I doing wrong?

    Please Login or Register  to view this content.
    Last edited by AKarmyguy; 05-03-2010 at 02:48 AM. Reason: add code tags

  2. #2
    Registered User
    Join Date
    05-03-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Compile Error Expected: End of statement

    Instead of hyphens (-) shouldn't you be using periods (.) ?

  3. #3
    Registered User
    Join Date
    05-03-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Compile Error Expected: End of statement

    I've also noticed that you have the word "Range" on the same line as your comment.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Compile Error Expected: End of statement

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

    Code tags added this time
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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