Defining variable value by excel formula

Application.Worksheetfunction.formulaname

This will help while defining loops. A variable can be defined for the number of times loop should run. This can be done by defining formula to variable.