Hi Howard

No need for a macro.
In Z2 enter
=IF(OR(B2="A",B2="B"),MIN(MIN(C2:K2),MIN(M2:U2))," ")

Copy down the sheet, as far as you wish.
As rows become populated, then the formula will produce the result.

--
Regards
Roger Govier

Howard Brazee wrote:
I have a VB enabled Excel document.

One tab has a value in Column B. If that value is "A" or "B", I want
to create a row somewhere that contains the lowest value of the
corresponding columns C, D, E, F, G, H, I, J, K, M, N, O, P, Q, R,
S, T, U

This tab is growing. Could someone assist me in creating this row?