+ Reply to Thread
Results 1 to 2 of 2

RunMacro with repeat expresion - problem with if statement

  1. #1
    Registered User
    Join Date
    07-27-2021
    Location
    NL
    MS-Off Ver
    2013
    Posts
    8

    RunMacro with repeat expresion - problem with if statement

    Hello dear coleagues,

    I have a table "Table1" that have 6 records in "Test1" field and yes/now field "YN". I have a loop that ticks YN box and I want it to stop when amount of ticked boxes = amount of records

    In repeat expression field I wrote
    Please Login or Register  to view this content.
    But when I try to save there is error message "The runmacro macro has an invalid value for the repeat expression argument"

    Any help would be appriciated!
    Last edited by Marcinrd; 07-29-2021 at 06:24 AM.

  2. #2
    Registered User
    Join Date
    07-27-2021
    Location
    NL
    MS-Off Ver
    2013
    Posts
    8

    Re: RunMacro with repeat expresion - problem with if statement

    I managed to solve it on my own the error was concerning how I refered to table should be "" instead of []. And eventually I shortened it to
    Please Login or Register  to view this content.

+ 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] Open/RunMacro/Save&Close Macro
    By JPSIMMON in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2015, 03:06 PM
  2. repeat if statement
    By superchew in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-27-2015, 07:58 PM
  3. [SOLVED] How to filter a known expresion from a text
    By Sith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2014, 06:00 PM
  4. If Cell=1 runMacro X If cell=2 RunMacro Y
    By dlast in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-20-2013, 06:03 AM
  5. Replies: 0
    Last Post: 11-22-2011, 04:04 AM
  6. Excel 2007 : Separate expresion into cell
    By ALEZI in forum Excel General
    Replies: 3
    Last Post: 07-23-2010, 09:22 AM
  7. Runmacro action was canceled error
    By sai_htwe in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2009, 11:55 AM

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