Loop Application.Run with variable parameter

  • Hi all


    I would like to loop Application.Run
    The aim is to run an excel addin called "bbs_remote" which requires 4 parameters i.e. [Class], [Qualifier], [Category], [Identifier]. These are currently named ranges on a sheet. they are strings.
    One of the parameters [Qualifier], I want Application.Run to loop through a number of [Qualifier] while keeping the other parameters constant.
    Here are 3 examples of [Qualifier]
    INT_LPL_BB1_2017
    INT_LPL_BB1_2018
    INT_LPL_BB1_2019


    Here is some code that does not have a loop yet;



    Any help at all will be much appreciated, thank you!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!