The following array formula is working correctly, but instead of a100 (end
limit) I have to use variable which value is changing time to time . How to
rewrite the
command to do this task?

Range("b2").FormulaArray = "=MIN(if(a2:a1000,a2:a100))"