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;

Please Login or Register  to view this content.

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

Thanks for your help. I tried this and it's almost there!

I've attached the full code below, basically there are 3 sections.
First section is getting the data and naming it x
Second section is writing a selected set of heading names from x
Third section is writing the data from x under the selected headings

I have put the Next qual, right at the bottom of this procedure. So it will loop back up to the First section after each set of data is done.
However since the headings are already there, running the second section actually keeps writing the Heading names offset by 1 cell from 1st run. Is it possible to skip the Second section and move straight onto Third section?

On the Third section I want to write data from x 2nd run offset by a row (basically on the row directly under the first run, and so forth)

Please Login or Register  to view this content.

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