+ Reply to Thread
Results 1 to 4 of 4

Macro for Combinations

  1. #1
    Registered User
    Join Date
    03-20-2013
    Location
    Costa Rica
    MS-Off Ver
    Excel 2003
    Posts
    9

    Macro for Combinations

    I found some code on the internet that is giving me a syntax error. Not sure what is wrong with it as I know nothing about VBA:
    Please Login or Register  to view this content.

    Above I put the two parts that are apparently wrong with the formula. I am hoping to use it in different sheets and change the numbers above to run different results. Any help would be greatly appreciated.

    Thanks

    Dexter
    Last edited by Leith Ross; 06-27-2013 at 09:59 PM. Reason: Added Code Tags

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Macro for Combinations

    For k = 1 To j 1 <----------This is highlighted in BLUE
    It said syntax error, i delete the - and type minus again myself. Then it worked.
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  3. #3
    Registered User
    Join Date
    03-20-2013
    Location
    Costa Rica
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Macro for Combinations

    Quote Originally Posted by wenqq3 View Post
    It said syntax error, i delete the - and type minus again myself. Then it worked.
    Thank you so much......I feel like an idiot.

  4. #4
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Macro for Combinations

    NP, thank for feedback. We always learn from mistake.

+ 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